Microsoft Access 2010 Bible

Part I: Access Building Blocks

218

Moving within a datasheet

You easily move within the Datasheet window using the mouse to indicate where you want to

change or add to your data — just click a field within a record. In addition, the ribbons, scroll

bars, and Navigation buttons make it easy to move among fields and records. Think of a datasheet

as a spreadsheet without the row numbers and column letters. Instead, columns have field names,

and rows are unique records that have identifiable values in each cell.

Table 6.1 lists the navigational keys you use for moving within a datasheet.

TABLE 6.1

Navigating in a Datasheet

Navigational Direction Keystrokes

Next field Tab

Previous field Shift+Tab

First field of current record Home

Last field of current record End

Next record Down arrow (↓)

Previous record Up arrow (↑)

First field of first record Ctrl+Home

Last field of last record Ctrl+End

Scroll up one page PgUp

Scroll down one page PgDn

Using the Navigation buttons

The Navigation buttons (shown in Figure 6.2) are the six controls located at the bottom of the

Datasheet window, which you click to move between records. The two leftmost controls move you

to the first record or the previous record in the datasheet. The three rightmost controls position

you on the next record, last record, or new record in the datasheet. If you know the record number

(the row number of a specific record), you can click the record-number box, enter a record num-

ber, and press Enter.

Note
If you enter a record number greater than the number of records in the table, an error message appears stating
that you can’t go to the specified record.