Microsoft Access 2010 Bible

Part I: Access Building Blocks

216

Note
Many of the behaviors described in this chapter apply equally to Access forms. Most Access forms display data
from a single record at a time, and interacting with the data on such a form is much like working with data in a
single row of a datasheet.

Datasheets are completely customizable, which allows you to view data in many ways. Changing

the font size, column widths, and row heights makes more or less of the data fit on the screen.

Rearranging the order of the rows and/or columns lets you organize the records and fields logically.

Locking columns makes them stay in position as you scroll to other parts of the datasheet, and hiding

columns makes them disappear. Filtering the data hides records that don’t match specific criteria.

Note
Datasheet view displays data from a number of different data sources: tables, queries, and forms displayed as
datasheets. Depending on the data source, some of the datasheet behaviors described in this chapter may not
work exactly as described. This is particularly true when the underlying data source is a query or form. With
these data sources, you might frequently find the datasheet is read-only.

FIGURE 6.1

A typical Datasheet view. Each row represents a single record in the table; each column represents a single
field (like Description or RetailPrice) in the table.

Scroll bar thumb

Scroll tip

Horizontal scroll bar

Vertical scroll bar