| Microsoft Access XP/2007 Level 1
6 hour class content:
- Introduction to Microsoft Access
- Access file types
- Access environment and toolbars
- Using the Office Assistant
- Using the database toolbars
- Using the task pane
- Creating a database from a new document or template
- The database menu bar
- The database window toolbar
- Creating and working with tables
- Creating a query
- Using a creating forms
- Displaying and linking images
- Creating and using reports
- Printing and Page Setup
- Practical Exercises
Microsoft Access XP/2007 Level 2
(Access 2007 is a 6 hour class)
Access XP/2003 4 hour class content:
- Designing tables in Access
- Establishing relationships
- Working with indexes
- Working with data types
- Designing Queries in Access
- Working with action and parameters queries
- Joining tables
- Designing data entry forms in Access
- Working with subforms
- Creating pop-up forms
- Creating and working with switchboards
- Designing reports in Access
- Working with standard, pop-up, subreports and data access
pages
- Creating pivot tables and pivot charts
- Importing and exporting data
- Building expressions
- Printing and Page Setup
- Practical Exercises
Visit
the
Microsoft Access
website!
|