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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
