12. Working with PivotTable and PivotChart Views

PivotTables and PivotCharts are powerful tools for summarizing detailed data stored in Access or SQL Server databases. Like crosstab queries, PivotTables present data generated by aggregate queries in a spreadsheet-like format that’s familiar to all accounting and management personnel. PivotTable views deliver to Access users the benefits of Excel worksheets without having to launch Excel to manipulate the data. PivotChart views automatically render PivotTable views as line, bar, or area charts. PivotTables and PivotCharts accomplish the primary objective of decision-support front ends—converting online transaction processing (OLTP) data to usable business information (BI).

PivotTables replace ...

Get Microsoft® Access® 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.