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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.