Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
9. Analyzing Data with Crosstab Queries and Pivot Tables > Pivot Tables
If totals queries and crosstab queries just don’t thrill you enough, Access has yet another high-powered feature for summarizing your data. A pivot table is a specialized table that performs the same tricks as a crosstab query—row and column grouping—but has even more muscle. Here are some of the extra features:
-
Pivot tables can be rearranged at any time. With a quick drag of the mouse, you can convert a sales-by-country summary to a sales-by-customer-age grid. That makes pivot tables great for data exploration, in which you try to ferret out hidden trends and relationships from an avalanche of raw data.
-
Pivot tables support unlimited levels of grouping. You aren’t limited to one level of column grouping, as you are in a crosstab query. Instead, you can subdivide your rows and columns into smaller and smaller groups.
