INTRODUCTION ACCESS 2003/2007

Class length:  six hours
Price:  $110.00

Database Software + tips & tricks

Topics include but are not limited to:

• database concepts
• designing a database
• creating a database
• creating tables
• lookup wizard
• table wizard
• adding data to a table
• keyboard shortcuts
• copying tables
• modifying structure
• finding data and replacing data
• sorting tables
• filtering tables
• forms
• queries
• reports
• database maintenance
• importing objects
• HELP
• compacting a database
• converting Access files
• printing

INTERMEDIATE ACCESS 2003/2007

Class length:  six hours
Price:  $110.00

Prerequisite is Introduction to Access.

Topics include but are not limited to:

• review
• Access objects interaction
• naming conventions
• database maintenance
• table options
• linking tables
• table relationships
• query options
• select queries
• selection criteria
• parameter queries
• update queries
• delete queries
• report options
• formatting
• hide repeating values
• report wizard
• label wizard
• report design view