Apps-B

Reminder: Access Project #2 Test on Wednesday

DAY #4 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,