Access 2003 Queries II: Creating Total, Crosstab, Parameter,
and Action Queries
Objective
Learn to create more advanced queries by building calculations,
creating total queries, defining crosstab queries, creating parameter
queries, and creating different action queries.
Prerequisite Skills
Course Description
Do you want to learn more advanced methods for filtering your
data? Do you want to learn how total, crosstab, parameter, 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 a parameter query to prompt users to enter criteria
for selecting records.
-
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)
