Using Access Databases
o Database Concepts
o Introducing Access 2007
o Introducing Database Objects
o Displaying Object Dependencies
o Displaying & Organizing Data
o Manipulating & Constraining Data
Tables
o Creating Access Databases
o Creating & Customizing Tables
o Displaying & Printing Table Data
o Customizing Field Properties
o Creating Table Relationships
o Creating Indexes
o Creating Lookup Fields
o Creating Multi-Valued Lookup Fields
Queries
o Creating Select Queries
o Find Duplicates Query
o Find Unmatched Query
o Customizing Queries
o Sorting & Filtering through Queries
o Building Query Expressions
o Using Parameters in Queries
Forms
o Creating Simple Forms
o Designing Forms from Scratch
o Customizing Form Properties
o Creating Form Controls
o Creating Sub Forms
o Creating Search Screens
Reports
o Creating Simple Reports
o Designing Reports from Scratch
o Customizing Report Look & Feel
o Grouping & Sorting Report Data
o Creating Mailing Labels
o Adding Controls to Reports
o Previewing & Printing Reports
Exchanging Data
o Importing Data to Access Databases
o Exporting Data from Access Databases
o Linking Data with Access Databases
o Working with Saved Imports & Exports
