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