Lesson 1: Using Charts

• Creating a Chart
• Adding a Chart to a Form or Report
• Changing the Chart Type

Lesson 2: Using Subforms/Subreports

• Creating a Subform/Subreport
• Editing the Layout of a Subform
• Displaying a Subform in Datasheet View
• Creating Navigation Forms
• Creating a Tab Hierarchy

Lesson 3: Working with Indexes

• Creating a Single Field Index
• Creating a Multiple Field Index
• Creating a Multiple Field Primary Key

Lesson 4: Using Access and the Internet

• Creating a Hyperlink Field
• Inserting a Hyperlink Field

Lesson 5: Using Access Database Security

• Encrypting/Decrypting a Database
• Assigning a Database Password
• Removing a Database Password

Lesson 6: Creating Macros

• Creating a Macro
• Assigning an Argument to an Action
• Saving a Macro
• Editing an Existing Macro
• Creating a Macro using the Macro Builder

Lesson 7: Using Macros

• Creating Embeded Macros
• Assigning a Macro to a Control
• Creating a Command Button
• If Then Else Statements
• Using Macros in a Table
• Creating and Using Submacros

Lesson 8: Customising the Navigation Pane

• Creating Custom Categories
• Creating Custom Groups
• Deleting Objects from the Group

Lesson 9: Exporting Data

• Exporting Data to an Excel Workbook
• Saving Export Steps
• Dragging and Dropping

Lesson 10: Using Switchboards

• Creating a Switchboard Form
• Adding a Command Button to a Switchboard
• Setting Startup Options