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