• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Working with PivotTable and ... > Understanding the Role of PivotTable...

Understanding the Role of PivotTables and PivotCharts

PivotTables and PivotCharts are powerful tools for summarizing detailed data stored in Jet 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 information.

Office 2000 introduced the Microsoft Office PivotTable 9.0 ActiveX control—a lightweight version of the Excel 2000 PivotTable—and the Chart 9.0 control, a substitute for the Microsoft Graph OLE server application. Microsoft designed these two controls primarily for use with data access pages (DAP) and intranet applications, but you also could insert them in Access forms or reports. The original PivotTable and Chart controls were members of the Office 2000 Web Components (OWC) 9.0, which required an Office 2000 license and Internet Explorer (IE) 5+ for users to view them. These licensing restrictions made Access 2000’s DAP unsuitable for public consumption via the Internet. Other deficiencies in Access 2000’s DAP implementation limited their deployment on private intranets.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint