O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required