O'Reilly logo

Microsoft® Access® 2010 In Depth by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required