Microsoft Office® Access 2007 Inside Out

Working with PivotChart Forms

Even when the main purpose of your application is to enter, store, and organize data to support an active business function, you probably want to add features that allow management to analyze the business processes. PivotTables and PivotCharts are ideal for this purpose. In Chapter 8, you learned how to create the PivotTable and PivotChart views of a query. Designing the PivotTable or PivotChart view of a form is exactly the same with some interesting twists:

• You can use any query or table as the record source of the form, but only fields bound to controls on the form are available to design the PivotTable or PivotChart.

• You can set form properties to control what users can modify in the PivotTable or PivotChart view, ...