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

Chapter 36. Access and the Web > Inserting a PivotTable in a Data Access Page

Inserting a PivotTable in a Data Access Page

You can add a PivotTable to a data access page. Users can then reorganize and summarize the data in their Web browser and move columns to rows or rows to columns.

To add a PivotTable:

1.
With the page open in Design view, click the Office PivotTable button on the toolbox (Figure 36.25).

Figure 36.25. The Office PivotTable button


2.
Click the PivotTable pointer where you want the upper left corner of the PivotTable to appear.

3.
Drag a table or query from the Field List task pane to the PivotTable. (Figure 36.26).

Figure 36.26. Drag a table or query to the PivotTable.


4.
Right-click the PivotTable, choose Commands and Options from the shortcut menu, and use the options on the Commands and Options dialog box to modify the PivotTable (Figure 36.27)

Figure 36.27. The Commands and Options dialog box for the PivotTable.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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