• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 19. Access and the Internet > Saving PivotTables and PivotCharts to Data A...

Saving PivotTables and PivotCharts to Data Access Pages

Access allows you to easily add PivotTables and PivotCharts to the data access pages that you create. Here's the process:

1.
From the Database window, click Pages in the list of objects.

2.
Double-click the Create Data Access Page in Design View item.

3.
Activate the field list.

4.
Click and drag a table or query to the data access page. The Layout Wizard appears (see Figure 19.27).

Figure 19.27. The Layout Wizard, where you can add a PivotTable or PivotChart.


5.
Select PivotTable and click OK. If you based the data access page on a query and the query required parameters, the Enter Parameters dialog box appears (see Figure 19.28).

Figure 19.28. The Enter Parameters dialog box, which allows you to specify parameter values.


6.
Click OK. Access adds the PivotTable to the data access page (see Figure 19.29). The PivotTable appears as a control on the data access page.

Figure 19.29. A PivotTable appearing as a control.


7.
Right-click the control and select Commands and Options from the context menu. The Commands and Options dialog box appears (see Figure 19.30). Click the Behavior tab.

Figure 19.30. The Commands and Options dialog box.


8.
Select the Drop Areas and Toolbar check boxes. The resulting PivotTable appears as shown in Figure 19.31.

Figure 19.31. A PivotTable that contains drop areas.


9.
Switch to Form view and enter any necessary parameters.

10.
Drag and drop row and column headings to the Drop Filter Fields Here and Drop Column Fields Here drop zones, as desired.

11.
Use the filter drop-downs to apply desired filters.

12.
Save your work.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint