Microsoft® Office Access™ 2007 Plain & Simple

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 ...