Access 2007 Queries II: Creating Total, Crosstab, and Action Queries

Objective

Learn to create more advanced queries by building calculations, creating total queries, defining crosstab queries, and creating different action queries.

Prerequisite Skills

Comfortable creating and working with Access databases and tables.
(Suggested courses: Access 2007 Getting Started, Access 2007 Making the Most of Tables, and Access 2007 Working with Table Relationships)
Comfortable creating simple Access queries
(Suggested course: Access 2007 Queries I)

Course Description

Do you want to learn more advanced methods for filtering your data? Do you want to learn how total, crosstab, and action queries can help you view, select, and analyze your data at a higher level?

Attend this course if you want to:

Understand advanced queries.
Build calculations in a query.
Use total queries to apply calculations to selected data.
Create a crosstab query to summarize data in a compact format.
Create an action query to change selected data within a table.

Class Length

90 minutes

Delivery Options

Virtual classroom - public
($70 per student; check times and register here)
Virtual classroom - dedicated (up to ten people from the same organization)
($480 per class; contact us for more details)
Virtual classroom - one on one
(Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)
On-site instructor-led
(Contact us for details)