Microsoft Office Tutorials and References
In Depth Information
Adding and Editing Records
Buttons: Click the record-navigation buttons in the bottom-left corner
of the datasheet (refer to Figure 1-7), or click the New Record button on
the toolbar to jump to the end of your listings.
Table 1-1
Datasheet Navigation Keystrokes
Keystroke
Where It Takes You
Page Down
Down a page
Page Up
Up a page
Tab
Next cell
Shift+Tab
Previous cell
Home
First field of the current record
End
Last field of the current record
Ctrl+
First record of the current field
Ctrl+
Last record of the current field
Ctrl+Home
First record of the first field (top-left corner of the datasheet)
Alt+F5
Record Number box (type a record number and press Enter
to go to that record)
If you know the number of the record you want (such as the fourth record
in the table), type the record number in the Record box at the bottom of the
datasheet (refer to Figure 1-7) and then press Enter.
Record numbers are relative; Access doesn’t assign permanent numbers
to records. Sorting the datasheet so that records appear in a different order
means that record numbers in the datasheet may change.
Adding and Editing Records
To create a new record, start typing in a blank row. To move to a blank row,
click one of the two New Record buttons (one nestled with the record
navigation buttons in the bottom-left corner of the datasheet and the other in the
Records group on the Home tab of the Ribbon), or press Ctrl++ (hold Ctrl
and type a plus sign). Type your data for the field, and press Enter or Tab to
move to the next field. When you get to the last field of a record and press Tab
or Enter, Access automatically moves you to the first field of a new record.
As you enter data, you may come across fields that are check boxes or
dropdown menus. You can easily use the mouse to change a check-box setting or
make a choice from a menu, but you can also use the keyboard, as follows:
Search JabSto ::




Custom Search