How To Use Pivottables In Access 2010


show more PivotTables provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

PivotTables

PivotTables allow you to interactively analyze data along two or more dimensions. Let's take a look at our Profit Margin by product. Click once on the Products table. Then go up to the Create tab and then click on the More Forms button. Drop it down, and choose PivotTable at the bottom. In the Show/Hide group on the left-hand side, click on Field Lists until you get a PivotTable Field List on the right. You have a screen with several zones for you to drag your fields. Click on Product and drag it to the left- hand zone, where it says Drop Row Fields here.

This will group all of our Olive Oils by Olive type. Pick up Size and drag it where it says Drop Column Fields here. This will now show you all the different sizes of each bottle, and drag Profit into the center area. You can now see the Profit Margin for each bottle size in the grid. Also drag Profit over to this Grand Total, and we can see our Total Profit. Now when I do that, it does open up a Subtotal and a Grand Total, which we ...

PivotTables
Video duration: 2m 29s 3h 30m Beginner

Viewers:

PivotTables provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...