Viewing Outlook Data in PivotTables and PivotCharts
In previous Access versions, you could view the contents of an Access database as a PivotTable by exporting it to Excel. Access 2002 builds PivotTable and PivotChart capabilities directly into Access. You can view any table, query, or form in either PivotTable or PivotChart view to analyze the data. You can also save PivotTable and PivotChart views as Data Access Pages viewable in a browser.
To create a PivotTable view of a table, open the table in Datasheet view and then choose View, PivotTable View. As shown in Figure 35.9, you can drag columns from the Field List to the "drop zones" on the PivotTable canvas to build the PivotTable.
Figure 35.9. Access PivotTables work much like their Excel ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
