Lesson 1: Getting started

• Database concepts
• Exploring the Access environment
• Getting help
• Closing a database and Access

Lesson 2: Databases and tables

• Planning and designing databases
• Exploring tables
• Creating tables

Lesson 3: Fields and records

• Changing the design of a table
• Finding and editing records
• Organizing records

Lesson 4: Data entry rules

• Setting field properties
• Working with input masks
• Setting validation rules
• Using indexes

Lesson 5: Simple queries

• Creating and using queries
• Modifying query results and queries
• Performing operations in queries

Lesson 6: Using forms

• Creating forms
• Using the Form Wizard
• Using Design view
• Finding, sorting, and filtering records

Lesson 7: Working with reports

• Creating reports
• Modifying and printing reports