Topics to know for the Access Lab Test

You should know how to do these tasks. Not all of them will be included on the test, but the test tasks will be chosen from this list.

• Start Access
• Exit Access
• Create a database
• Open an existing database
• Save a database
• Create a table in a database
• Define a structure
  • field name
  • field type
  • field width
  • primary keys
• Add records to a table
• Create a report
• Create a Query
• Run a Query
  • Use more than one table
  • include all fields
  • enter criteria
  • use compound criteria - And, Or
• Sort data in a query
• Sort by multiple fields, "by A within B"
• Make relationships between Tables
• Use Comparison operators in a query
• Use Calculated Fields in a query
• Calculate Statistics
  • Grouping
  • Average
  • Sum
  • Minimum, Maximum
• Search for a record
• Delete records
• Change the Structure
• Validation Rules
• Referential Integrity
• Creating Forms
• Making a field indexed
• Exporting a table as a PDF file

Access Tutorials

• Nice set of Access Tutorials