O'Reilly logo

Microsoft® Office Access™ 2007 Plain & Simple by Curtis D. Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a PivotTable

Access databases let you gather and present important data, but the standard table only shows a list of values. Forms and reports let you summarize and display your data so it’s easier to evaluate, but you’re still limited to a single view of your data. Even queries, which let you perform calculations on your data or present it in a crosstab worksheet, give you a single view of your data. PivotTables, by contrast, let you rearrange your data dynamically. If your PivotTable lists sales by category and you’d rather see the data organized by country, you can change the layout of your PivotTable quickly. Once you create your first PivotTable, you understand how powerful a tool they are!

Create a PivotTable Form

  1. Click the table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required