Access 2007 Queries I: Creating Select Queries
Objective
Learn to create simple queries, modify queries, create multiple-table
queries, and apply calculations to 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)
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.
-
Sort and filter records in a table.
-
Save a filter as a query.
-
Use a wizard to create a simple query.
-
Create a query using the Design view.
-
Modify and save a query.
-
Set properties for a query.
-
Build multiple table queries.
-
Add criteria to a query.
-
Add parameters to a query.
-
Apply simple calculations 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)
