Access 2010 Creating Select Queries

Objective

Learn to create simple filters and select queries, modify queries, create multiple-table queries, create Top(n) queries, set criteria in queries, and use parameters in queries.

Prerequisite Skills

Comfortable creating and working with Access databases and tables.

Course Description

Have you created a database, but now want to view, change, or analyze only certain data within it? Do you want to sort or filter your data to work with it more effectively? Do you want to select specific data for inclusion in a form or report?

Attend this course if you want to:

Learn about different types of queries.
Filter tables or queries.
Use a wizard to create a simple query.
Add a total row to query results.
Use a wizard to find duplicate records in a table.
Create a query using the Design view.
Modify a query.
Add criteria to a query.
Delete queries you no longer need.

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)