• Manage the Access environment

1. Create and manage a database
2. Configure the Navigation pane
3. Apply Application Parts

•  Build tables

1. Create tables
2. Create and modify fields
3. Sort and filter records
4. Set relationships
5. Enter and format text
6. Import data from a single data file

•  Build forms

1. Create forms
2. Apply Form Design Tab options
3. Apply Form Arrange Tab options
4. Apply Form Format Tab options

•  Create and manage queries

1.  Construct queries
2. Manage source tables and relationships
3. Manipulate fields
4. Calculate totals
5. Generate calculated fields

• Design reports

1. Create reports
2. Apply Report Design Tab options
3. Apply Report Arrange Tab options
4. Apply Report Format Tab options
5. Apply Report Page Setup Tab options
6. Sort and filter records for reporting