Microsoft® Office Access™ 2007 Plain & Simple

Chapter 16. Presenting Table and Query Data Dynamically

In this section:

• Creating a PivotTable

• Adding and Removing PivotTable Fields

• Pivoting a PivotTable

• Filtering PivotTable Data

• Formatting a PivotTable

• Creating a PivotChart

The capabilities Microsoft Office Access 2007 places at your disposal are wide-ranging and powerful. You can build tables to store data effectively, ask questions of the data using queries, and display the data in forms and reports. What’s even better, you can use many of those techniques in a single database object: the PivotTable Report.

When you create a PivotTable, you build a versatile object you can use as part of live business presentations to illustrate your own points and answer your colleagues’ questions quickly. If you’d ...