LESSON 1 - Access Basics

• Understanding Databases
• Using Database Templates
• Open an Existing Database
• The Access Environment
• Working with Database Objects
• Creating a Blank Database
• Setting Access Options
• Using Help

LESSON 2 - Working with Tables

• Using Table Templates
• Entering Data into a Table
• Adding New Fields to a Table
• Creating a Table from Scratch
• Setting a Primary Key
• Changing Column Width and Row Height
• Rearranging Fields
• Inserting and Deleting Fields
• Changing Field Properties
• Designing in Datasheet View

LESSON 3 - Working with Data

• Editing Data
• Formatting Table Data
• Importing Excel Data into an
  Existing Table
• Importing a Text File into a New Table
• Selecting and Deleting Records
• Sorting Records
• Finding and Replacing Data
• Filtering Data by Selection
• Filtering Data by Form
• Using Common Filters
• Hiding/Unhiding Columns
• Freezing Columns
• Rearranging Columns
• Displaying Column Totals in a Datasheet

LESSON 4 - Working with Queries

• Working in Query Design View
• Creating a Query in Design View
• Adding Fields to a Query
• Removing Fields from a Query
• Saving a Query
• Running a Query
• Adding Criteria to a Query
• Specifying Multiple Criteria
• Sorting Data in a Query
• Moving Columns in a Query
• Using the Query Wizard

LESSON 5 - Creating Forms

• Using the Form Wizard
• Entering Data into a Form
• A Look at Design View
• Adding a Field to a Form
• Changing Control Properties
• Layout View
• Finding Records in a Form

LESSON 6 - Creating Reports

• Creating a Basic Report
• Autoformatting a Report
• Using the Report Wizard
• Report View and Layout View
• A Look at Design View
• Modifying Report Setup
• Printing Reports
• Using the Label Wizard