Pivot Tables

If you need more advanced interactivity, you can make a PivotTable based on the same qryNorthwindAll query. In Access 2007, the process of creating a PivotTable has been simplified; just select the data source query or table, then, as depicted in Figure 1.24, select PivotTable from the More Forms menu of the Forms group in the Create tab of the Ribbon.

FIGURE 1.24

Creating a PivotTable.

FIGURE 1.24

Creating a PivotTable.

A new form based on the data source opens in PivotTable view (see Figure 1.25), with the Field List open so you can drag fields to the drop zones of the PivotTable, one field each to the Row Fields, Column Fields, and (optionally) Filter Fields drop zones, which are indicated in gray text at the upper-left corner of the form. The data field to be displayed in the body of the table is dragged to the drop zone in the center of the form; Access will automatically create a Count or Sum field when appropriate.

0 0

Post a comment