Microsoft® Access® 2010 Inside Out

Working with Client 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 10, you learned how to create the PivotTable and PivotChart views of a client query. Designing the PivotTable or PivotChart view of a client form is the same, but 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 ...