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 - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
Using wildcards5m 33s
-
Using IN instead of OR1m 34s
-
Hiding query fields50s
-
Changing captions1m 42s
-
Finding duplicate records2m 17s
-
Moving records with append and delete queries4m 32s
-
Using make-table queries2m 23s
-
Creating an update query2m 49s
-
Turning a query into a PivotTable2m 22s
-
Turning a query into a PivotChart2m 8s
-
Using SQL statements2m 27s
-
-
-
-
-
-
-