Apps-T

Reminder: Access Project #2 Test Today!

DAY #5 ACCESS PROJECT #2 – QUERYING A DATABASE

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

  • SAVE ALL STEPS BY YLN-LAB #1-STEP #
  • SAVE ALL STEPS BY YLN-LAB #2-STEP #

LAB #1 – Querying the Garden Naturally Database

  • OMIT Step #12, #13, #14
  • SAVE AS – Access 2 – Lab #1 Printouts

Printing Lab #1

  • Page #1 – Steps #1, #2, #3, #4, #6
  • Page #2 – Steps #7, #8
  • Page #3 – Steps #9, #10, State Sales Rep Crosstab

LAB #2 – Querying the Museum Gift Shop Database

  • OMIT Step #15
  • SAVE AS – Access 2 – Lab #2 Printouts

Printing Lab #2

  • Page #1 – Steps #1, #2, #3, #4
  • Page #2 – Steps #5, #6, #7, Vendor Item Query
  • Page #3 – Steps #12, #13, #14

Access #2 Word Bank

MIN, OR, aggregate, fixed-width, ?, parameter, asterisk, Wildcards, AND, Datasheet, primary sort, asterisk, property sheet, query,