Chapter 9. Queries, Part II

This chapter focuses on several types of queries that can help you review and analyze your data. Parameter queries make it easy to quickly change criteria so you can retrieve the records for, say, Nevada instead of Nebraska. You use total queries to find sums, averages, and other aggregates. Crosstab queries are sophisticated total queries that help you break down data for easier analysis.

A fourth topic, action queries, is also included, although it's a slightly uncomfortable fit. Virginia Woolf told us that “A rose is a rose is a rose.” But if she ever met an action query, I doubt she would say “A query is a query is a query.” Unlike the select queries that are central to your day-to-day Access work, action queries ...

Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.