Microsoft Office Tutorials and References
In Depth Information
Adding and Editing Records
Press the spacebar to change a check-box setting from selected to
deselected, or vice versa.
Press F4 to open a drop-down menu, press the ↓ key to make your
choice, and then press Enter.
If you change your mind about your entry, press the Esc key to cancel it. If
you’ve already pressed Enter, you can undo the last entry by clicking the
Undo button (a small button on the toolbar above the Ribbon) or pressing
Ctrl+Z (a shortcut for Undo in many applications). Another useful keystroke
to know is Ctrl+’ (apostrophe), which repeats the value in the record
immediately above the cursor.
Book II
Chapter 1
Table 1-2 lists all the keystrokes you’ll ever need to enter and edit data.
Table 1-2
Keystrokes in Datasheet View
Keystroke
What It Does
Ctrl++ (plus sign)
Moves the cursor to a new record
Enter or Tab
Enters the data and moves to the next cell to the right or to
the first field of the next record
Esc
Cancels the current entry
Undo or Ctrl+Z
Undoes the last entry
F4
Displays a drop-down menu (if one is present) in the current
cell
Ctrl+C
Copies the selected data
Ctrl+X
Cuts the selected data
Ctrl+V
Pastes data from the clipboard
Delete
Deletes the selected data
Ctrl+Enter
Enters a line break within an entry
Ctrl+–
Deletes the current record
Spacebar
Switches between the values in a check box or option button
Chapter 4 of this minibook covers cutting, copying, and pasting in detail.
Using keystrokes to enter data automatically
Access has a few extremely convenient keystrokes that enter data for you
automatically, and they’re listed in Table 1-3.
Search JabSto ::




Custom Search