• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Working with Pivot Tables

Chapter 11. Working with Pivot Tables

This chapter introduces you to one of the most powerful and flexible tools in your Access arsenal: the pivot table. Pivot tables aren't native to Access—they're actually Microsoft Excel objects available to those with both Access and Excel installed on their system.

You can think of pivot tables as an extension of the crosstab query, discussed in Chapter 5. Like crosstab queries, pivot tables present data in a spreadsheet, with each cell in the body of the table at the intersection of a column and row. Datasheets present data in the same manner, but don't give you the same capabilities (such as formulas) that spreadsheets give you. Pivot tables go beyond simple crosstab queries by allowing you to change how the table displays your data in much the same way you can change the priority order of grouping fields for reports (see Chapter 6).

Perhaps the most important aspect of pivot tables is the time they save. Rather than creating a separate query or form to display your data differently, you can modify your pivot table to arrange your data in the most effective way. Every unique arrangement of the fields in your pivot table tells a story.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint