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

Chapter 1. Access 2003 for Access 97 and... > PivotTable and PivotChart Views

PivotTable and PivotChart Views

Access 2000 introduced the Office Web Components (OWC), which include PivotTable, PivotChart, and Spreadsheet ActiveX controls, for use with Data Access Pages. Access 2002 added PivotTable and PivotChart views of tables, queries, and forms in traditional Access applications, ADP, and DAP. In most cases, PivotTable and PivotChart views use summary or crosstab queries as their data source. Data in conventional relational tables seldom is suited to display in either of these new views. You can specify the default view of a table, query, view, or function to be a PivotTable or PivotChart.


PivotTables let you manipulate a spreadsheet-like view of data by increasing or decreasing the level of detail and filtering the data to reduce the number of rows, columns, or both. You also can rotate (pivot) the view by interchanging rows and columns. The PivotTable’s AutoCalc feature lets you generate the equivalent of a Jet crosstab query from detail or summary data and add grand totals to rows and columns. Transact-SQL (T-SQL), SQL Server’s query language, doesn’t have direct equivalents to the Jet SQL TRANSFORM and PIVOT statements that generate crosstab queries. You can use PivotTables to emulate Jet crosstab queries in ADP and DAP that use SQL Server as the data source.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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