One day hands-on training in Microsoft Access 2007 will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

Topics

• Analyze Tables
• Create a Junction Table
• Improve Table Structure
• 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
• Create a Macro
• Attach a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro
• Display a Calendar on a Form
• Organize Information with Tab Pages
• Display a Summary of Data in a Form
• Include a Chart in a Report
• Print Data in Columns
• Cancel Printing of a Blank Report
• Create a Report Snapshot
• Link Tables to External Data Sources
• Manage a Database
• Determine Object Dependency
• Document a Database
• Analyze the Performance of a Database

Target Audience
Anyone who wants to learn to use Microsoft Access 2007 to store database, create forms to enter data, develop queries to access data and generate report with data in a presentable format.

Prerequisite
Completed the Access 2007 Basic course or have a basic knowledge of Microsoft Access 2007, including database design and data tables.

Training Class Material: