Access Project 2 Ashton James College

Assignments:

Complete project 2 for both the Ashton James and Begon Pest Control Databases that you created in Project 1.

Concepts:

• Query  - creating, printing, saving, and reusing
  • Criteria
  • Wildcard - shortcuts for adding search criteria
    • *
    • ?
  • Parameter Query - a query that prompts for input when run
  • Compound Criteria
    • AND
    • OR
    • between
  • Sorting
  • Property sheet
  • Multiple Keys
  • Top Values query
  • Joining Tables
  • Restricting Records
  • Calculations
    • Expression Builder
  • Changing Format and Captions in a query using properties
  • Statistics (functions again)
  • Grouping
  • Crosstab Query