Special Edition Using Microsoft® Access 2000

Chapter 20. Using Access with Microsoft Excel

In this chapter

• Slicing and Dicing Data with PivotTables

• Creating the Query for the PivotTable

• Generating a PivotTable Form with the Wizard

• Manipulating PivotTables in Excel

• Improving PivotTable Formatting

• Slicing PivotTable Data

• Formatting PivotTable Reports

• Creating a PivotChart from a PivotTable

• Using Excel as an OLE Server

• Embedding a Conventional Excel Worksheet in a Form

• Troubleshooting

• In the Real World—OLAP and PivotTables

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