Chapter 14. Pivot Tables and Pivot Charts

In Chapter 9, “Queries, Part II,” you learned about crosstab queries; in this chapter, you learn about pivot tables. Both summarize data in two-dimensional matrixes. But pivot tables are much more powerful than crosstab queries: They add extra levels of detail for more in-depth analysis. They are extremely flexible, so you can “slice and dice” your data in many ways. They make it easy to find all kinds of totals, such as sums, counts, and averages, for many sets and subsets of data.

And pivot tables are fun. Yes, they do entail a learning curve. There's a lot going on in a pivot table, and you can set many properties that affect both substance and appearance. But when you know how pivot tables work, you'll ...

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.