ACCESS

Level 1
Be introduced to Microsoft Access
Learn database terminology
Become familiar with the Access 2002 interface
Use Microsoft Access databases
Work with table objects
Work with records in a table
Find, sort and filter records in a table
Create tables using the design view
Create tables with the Table Wizard
Discuss relational database design
Normalize databases
Create table relationships
Explore relationship types
Define referential integrity
Set table and field properties
Control data entry
Index fields

Level 2
Be introduced to SQL
Create select queries
Use criteria to refine query results
Create multi-table queries
Create query joins
Create Action Queries
Write SQL specific queries
Create calculated query fields
Implement query parameters
Create crosstab queries
Work with OLE objects
Import/export data
Link to MS Access databases
Use MS OfficeLinks
Work with PivotTable and PivotChart views (MS Access 2002 & 2003 only)

Level 3
Create forms in design view
Use field lists
Add and modify form controls
Work with control properties
Create calculated controls
Create tab, image and option group controls
Create and embed subforms
Use the Form Wizard
Create reports in design view
Modify report's page setup settings
Modify report design and layout
Work with report sections
Create summary functions
Create subreports
Use the Report Wizard
Use the Mailing Labels Wizard