Change an Access query's Default View Property to PivotTable

by Mary Ann Richardson | May 16, 2006 7:00:00 AM

Tags: Microsoft Office, Databases, Mary Ann Richardson, Microsoft Access, PivotTable, Default View Property, Datasheet, PivotChart View, Microsoft Office Suite Access Tips Newsletter

Takeaway: Are you still toggling Access queries back and forth between Datasheet and PivotTable or PivotChart views? Mary Ann Richardson shows you how to change the default view property of a query so it will open automatically to the correct view.

When you create an Access query to display in PivotTable or PivotChart View, your users have the ability to slice and dice the data any way they want. However, before Access 2002, users had to first run their query in the default Datasheet view, then switch to either PivotTable or PivotChart View before they could analyze the data. While Datasheet view is still the default, Access 2002 added the Default View Property to the Query property sheet. The Default View Property enables you to change the default, eliminating the need for users to switch views from Datasheet to PivotTable or PivotChart.

Here's how to change the Default View from Datasheet to PivotTable:

1. Open the query in Design view.
2. Right-click a blank area of the query design window and select Properties.
3. Click the Default View Property and select PivotTable from the drop-down list.

The query will now go automatically into PivotTable View when run.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.