Module 1: Database Management in access 2007
Compact and Repair a Database
Backing up Your Database
Editing Database Properties

Module 2: Linking Files in access 2007
Linking to an Excel Spreadsheet
Linking to Another Database
Linking to a SharePoint Site
Other Types of Linked Documents
Creating a Hyperlink

Module 3: Exporting Files in access 2007
Exporting to PDF or XPS
Exporting to Word or Excel
Exporting to Other Destinations
Using Saved Exports
Exporting to a CAB File
Exporting to Older Versions of Access

Module 4: Referential Integrity in access 2007
Using the Relationships View and Ribbon
Types of Relationships
Establishing Referential Integrity
Enforcing Referential Integrity
Testing Referential Integrity

Module 5: Table Relationships in access 2007
About Join Lines
Normalizing Tables
Using Cascade Delete and Cascade Update
Setting Fields for Indexing
Using the Index

Module 6: Switchboards in access 2007
Using a Switchboard vs. Using the Navigation Pane and Ribbon
Using the Switchboard Manager
Creating a Switchboard
Editing a Switchboard
Deleting a Switchboard

Module 7: Modal Dialog Boxes in access 2007
Creating a Modal Dialog Box
Adding Controls
Setting Properties
Formatting your Dialog Box

Module 8: Using Subforms in access 2007
Creating a Subform
Modifying a Subform
Working with a Subform
Synchronizing Subform Data with a Main Form
Displaying a Subform within a Main Form

Module 9: Advanced Form Tasks in access 2007
Creating Check Boxes and Command Buttons
Creating Event Procedures
Customizing Error Messages

Module 10: Exporting Your Form in access 2007
Sending a Form via E-Mail
Managing Replies
Exporting your Form to XML

Module 11: Creating a PivotTable in access 2007
About PivotTables
Creating a PivotTable
More about PivotTable Fields
Completing your PivotTable

Module 12: Creating a PivotChart in access 2007
About PivotCharts
Creating a PivotChart
More about PivotChart Field
Completing Your PivotChart

Module 13: Using PivotTables and PivotCharts in access 2007
Using a PivotTable
Using a PivotChart
Editing a PivotTable or a PivotChart
Common PivotTable and PivotChart Editing Commands
Creating a PivotTable and PivotChart from the Same Object

Module 14: An Introduction to SQL in access 2007
What is SQL?
Parts of an SQL Statement
SQL Keywords