Access 2007 Advanced

Course Length

Full day

Prerequisites

Access 2007 Intermediate or equivalent experience

Course Description

This course is for the individual whose job responsibilities include the need to create complex Access databases by structuring existing data, writing advanced queries, enhancing forms and reports, working with macros, and performing database maintenance.

Course Topics

• Analyze tables

• Create a junction table

• Improve the 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

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.

[Home   |   Services   |   Courses   |   Instructors  |  References  |  Contact Us]