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

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