From the course: Access 2007: Shortcuts

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Turning a query into a PivotTable

Turning a query into a PivotTable - Microsoft Access Tutorial

From the course: Access 2007: Shortcuts

Start my 1-month free trial

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 PivotTables. PivotTables allow you to interactively analyze your data along more than two dimensions. Let's start by understanding our scenario and our goal. I'm looking at my Orders Table and I can see the Date an Order was placed, the Customer who placed the order, the Product that they ordered, the number of bottles that they ordered, and the OrderStatus. If I go over to my Navigation pane and down to my Order Totals Query, it takes this same data but writes out the company and the product, I have the bottle size, the Price, the Quantity and an extended total amount. If I look at this in Design View in the right -hand column, I can see the new calculation. When I go over to the View button and click on the bottom half where it says View, I have some additional options. I am going to choose PivotTable View. Now I have a white grid with placeholders…

Contents