Making a Pivot Table in Access XP
Access XP automatically
“builds” the Pivot Table for you,
and you just have to install the appropriate fields into the
correct “landing zones.”
When the “Pivot
Table” icon is first placed on the data page’s “Design” grid,
Access XP displays all of the individual “landing zones” (my term) while Access
2000 does not.
Click on the
“Pivot Table” button (
) in the “Toolbox”
(after making certain that the “Wizard” button (
) is activated) :
Move the insertion
point to the upper left corner of the design grid and click :
Note that there
are no “target” areas designed on the design grid yet.
They will appear
after dragging the first field to the “Pivot table” control
which will “specify the source data” required.
Select the field
from the table or query to be used for the “Column”
data
and the field to be used for the “Row” data
:
In this example,
the “PositionTitle” is being used for the rows,
and the “State/Prov” field is used for the columns,
and the “Openings” field will be used for the
“body.”
To “initialize”
the pivot table, the “Openings” field will be moved
first.
Dragging the “Openings” field from the field list to the pivot table control
(without releasing the button yet) causes the “target area” to appear in a blue
rectangle :
Releasing the mouse button “initializes” the control :
(The “sizing handles” are not shown, but
appear around the edges)
Note that this causes the individual row and column
“target areas”
to appear in the pivot table control on the left and above the “Openings” field.
From this point, the procedure is much the same for Access 2000 and for Access XP.