Turning a query into a PivotTable


show more Turning a query into a PivotTable provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Turning a query into a PivotTable

You'll use queries extensively to explore your data, and you can actually take your analysis a step deeper by turning your queries into pivot tables. Pivot tables allow you to interactively analyze your data along more than two dimensions. Let's start by understanding our scenario and our goal. I have opened my Orders table, and I can see every order. The Date it was placed, the Customer who ordered it, the Products that they ordered, the Quantity that they ordered, as well as the OrderStatus. If I go down to my Queries, and I double-click on OrderTotals, I can see similar information with the addition of a grand Total row for that particular order.

When I look at it in Design View, here is each order with a calculation in the last column to find out the Total for that order. But if I go up to that toggle button, and I dropdown the bottom half, I have some additional options. Let's click on PivotTable View. When we choose it, a white grid appears with placeholders at the top ...

Turning a query into a PivotTable
Video duration: 2m 30s 3h 43m Intermediate

Viewers:

Turning a query into a PivotTable provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...