O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Pivot Table Properties

Pivot tables come with an array of features that either enhance your analytical power or simply make life easier and more pleasant. On the mundane side, you can change fonts and supply captions. On the much more interesting analytical side, you can create group items and filter for top (or bottom) values. Most of the fine-tuning is performed in the Properties dialog box, which is available from the context (shortcut or right-click) menus. The properties in the dialog box, as with those in the property sheet in a form, depend entirely on which element of the table you select.

Using the Top Values Property

As you might recall from Chapter 8, “Queries,” you use the Top Values property to show the best, the worst, the highest, ...

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