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.