Office Workspace Basics Time: 40 Min

• Printing Your Address Book
• Basic Window Elements
• Menu features
• Customizing Menus and Toolbars
• Getting Help

Introduction to Access Time: 60 Min

• What is an Access Database?
• Opening a Database File
• Introduction to the Database Window
• Exploring Database Objects
• Creating a Database
• Printing a Database
• Saving and Closing a Database File

Working with Tables Time: 70 Min

• What is a Table
• Working with Datasheets
• Moving between Records
• Updating Records
• Adding Records to a Table
• Selecting Rows and Columns
• Finding Records
• Sorting Records
• Filtering Records
• Using the PivotChart View
• Saving and Closing a Datasheet

Designing Tables Time: 70 Min

• Adding a Table to a Database
• Adding Fields to a Table
• Setting a Primary key
• Using the Input Mask Wizard
• Saving Design Changes
• Importing Data
• Exporting Data
• Performig Database Maintenance

Creating and Running Queries Time: 70 Min

• What is a Query?
• Creating a Query
• Woking with Queries
• Saving and Running a Query
• Creating and Calculated Fields
• Using Aggregate Functions
• Understanding Query Properties
• Creating Multi-Table Select Queries
• Joining Tables
• Enforcing Referential Integraty
• Printing Table Relationships

Using Forms Time: 70 Min

• What is a Form?
• Using an AutoForm
• Creating a Form with the Form Wizard
• Working in Design View
• Applying an AutoFormat
• Changing the Form Layout
• Using Calculated Controls
• Working with Records on a Form
• Creating Data Access Page

Generating Reports Time: 80 Min

• What is a Report?
• Creating an AutoReport
• Previewing and Printing a Report
• Saving a Report
• Designing a Report
• Changing the Report Layout
• Understanding Controls
• Using a Calculated Control
• Analyzing Depencies
• Creating Mailing Labels