Microsoft Access 2007, Class 3
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2007 Intermediate or equivalent experience |
| Course Materials: | Course manual with CD containing exercises |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the Advanced concepts of Microsoft Access 2007 with managing database objects, creating macros and graphic reports, understanding modules, and maintaining databases. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Structuring Existing Data
- Analyze Tables
- Create a Junction Table
- Improve Table Structure
Writing Advanced Queries
- Create Subqueries
- Create Unmatched and Duplicate
- Queries
- Group and Summarize Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
Making Effective Use of Forms
- Display a Calendar on a Form
- Organize Information with Tab Pages
- Display a Summary of Data in a Form
Making Reports More Effective
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Create a Report Snapshot
Maintaining an Access Database
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database