Creating and Using Databases
Create Access databases
Open database objects in multiple views
Move among records
Format datasheets

Creating and Modifying Tables
Create and modify tables
Add a predefined input mask to a field
Create Lookup fields
Modify field properties

Creating and Modifying Queries
Create and modify Select queries
Add calculated fields to Select queries

Creating and Modifying Forms
Create and display forms
Modify form properties

Viewing and Organizing Information
Enter, edit, and delete records
Create queries
Sort records
Filter records

Defining Relationships
Create one-to-many relationships
Enforce referential integrity

Producing Reports
Create and format reports
Add calculated controls to reports
Preview and print reports

Integrating with Other Applications
Import data to Access
Export data from Access
Create a simple data access page