Microsoft Access 2010 Bible

Part I: Access Building Blocks

248

Clicking on a column in the Totals row transforms the datasheet cell to a drop-down list. The

items in the drop-down list are specific for the column’s data type. For example, in text columns

the drop-down list shows only None and Count, while a numeric column contains a full comple-

ment of totals calculations (Sum, Average, Count, and so on). DateTime columns include None,

Average, Count, Minimum, and Maximum.

The Totals calculation you choose is dynamic. As you change data in the datasheet or underlying

table, the calculation results displayed in the Totals row are automatically updated after a very

short delay. Recalculating a lot of totals extracts a small performance penalty, so you might want to

hide the Totals row (described below) when its special features aren’t needed.

The Totals options you choose for the columns in a datasheet persist. If you close the datasheet

and report it, the Totals row is still there.

To remove the Totals row, open the datasheet and click the Totals button in the Records group on

the ribbon. One interesting behavior of the Totals row is, if you choose to remove it, you can restore

it later on (by clicking the Totals button again) and the row is restored to its original setting.

Printing Records

You can print all the records in your datasheet in a simple row-and-column layout. In Chapter 9,

you learn to produce formatted reports. For now, the simplest way to print is to click the Print

icon in the Quick Access toolbar. This prints the datasheet to the Windows default printer. Click

on the Microsoft Office Button to view other print options, shown in Figure 6.23.

FIGURE 6.23

The Microsoft Office Print menu