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
• Sorting and filtering data

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
• Using operators in queries

Lesson 6: Using forms

• Creating forms
• Using forms for data entry
• Finding, sorting, and filtering data

Lesson 7: Working with reports

• Creating reports
• Sorting and grouping report data
• Modifying and printing reports