Special Edition Using Microsoft® Office Access 2003

Chapter 12. Working with PivotTable and PivotChart Views

In this chapter

• Understanding the Role of PivotTables and PivotCharts

• Slicing and Dicing Data with PivotTables

• Creating the Query for a Sample PivotTable View

• Designing the PivotTable View of the Sample Query

• Setting PivotTable Property Values

• Exporting the PivotTable to Excel

• Optimizing Performance of PivotTables

• Formatting and Manipulating PivotCharts

• Troubleshooting

• In the Real World—Visualizing Data

Understanding the Role of PivotTables and PivotCharts

PivotTables and PivotCharts are powerful tools for summarizing detailed data stored in Jet or SQL Server databases. Like crosstab queries, PivotTables present data generated by aggregate queries in a spreadsheet-like format that’s familiar to all ...