Creates pivot tables. Pivot tables are interactive worksheet tables that allow you to summarize and analyze data from existing tables. You can choose either to save a pivot table directly in Microsoft Excel or to add one as an object on a form.
You must have Microsoft Excel with Microsoft Query installed on your computer in order to create a pivot table. For more information about pivot tables, see Microsoft Excel Help.
To run the PivotTable Wizard
Step 1 – Select Fields
Step 2 - Layout
Step 3 - Finish
For more information, see "Using Wizards" in Chapter 1, Getting Started, in the User's Guide.