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.