Microsoft® Access® 2010 Plain & Simple

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

Microsoft Access 2010 places wide-ranging and powerful capabilities at your disposal. You can build tables to store data effectively, ask questions of the data using queries, and display the data in forms and reports. 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 rather summarize your ...