Microsoft Office Tutorials and References
In Depth Information
Completed chart in Form view
10. Close the form.
Sarah wants to know if Access has other charting and data analysis tools. You’ll show
her how to create a PivotTable and a PivotChart.
Creating and Using a PivotTable
Sarah wants to be able to analyze Belmont Landscapes’ business in a flexible way. You
can use PivotTables to provide the flexible analysis that Sarah needs. A PivotTable is an
interactive table that lets you analyze data dynamically. You can use a PivotTable to view
and organize data from a database, look for summary or detail information, and dynami-
cally change the contents and organization of the table. Figure 8-27 shows a PivotTable.