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

Chapter 20. Using Access with Microsoft ... > Slicing and Dicing Data with PivotTa...

Slicing and Dicing Data with PivotTables

Excel's PivotTable feature, which originated with Excel 5.0, delivers extraordinarily ad hoc data analysis capability, often called "slicing and dicing" the data. Chapter 18, "Designing Data Access Pages," shows you how to use the PivotTable ActiveX control—a lightweight version of the Excel 2000 PivotTable that's designed primarily for intranet applications. This chapter shows you how to take full advantage of Excel 2000 PivotTables embedded in Access 2000 forms. You need a local copy of Excel 2000 to perform this chapter's examples.

Note

Excel PivotTables are Microsoft's preferred method for presentation of OLAP data from Microsoft OLAP Services for SQL Server. To aid developers, Microsoft supplies an OLE DB PivotTable Service provider that works with data cubes. Learning how to create Excel PivotTables from Jet databases is a helpful introduction to the more complex process of presenting data cubes in PivotTables.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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