Hermit's Free Library Keyboard Shortcuts
In addtion to the standard keyboard shortcuts common to most Windows applications (such as Copy, Cut, and Paste), there are some specialized shortcuts available in MS- Access. They are summarized in the following tables.
|
Modifiers |
Key |
|
|
Undoing typing |
Ctrl+ |
Shift |
|
To undo changes in the current field or current record; if both have been changed, press ESC twice to undo changes first in the current field and then in the current record |
|
ESC |
| Modifiers | Key | |
| To insert the current date | Ctrl+ | Semicolon (;) |
| To insert the current time | Ctrl+ | Colon (:) |
| To insert the default value for a field | Ctrl+Alt+ | Spacebar |
| To insert the value from the same field in the previous record | Ctrl+ | Apostrophe (') |
| To add a new record | Ctrl+ | Plus Sign (+) |
| To delete the current record | Ctrl+ | Minus Sign (-) |
| To save changes to the current record | Shift+ | Enter |
| To switch between the values in a check box or option button | Spacebar | |
| To insert a new line | Ctrl+ | Enter |
| Modifiers | Key | |
| To recalculate the fields in the Window | F9 | |
| To requery the underlying tables; in a subform, this requeries the underlying table for the subform only | Shift+ | F9 |
| Refresh the contents of a Lookup field list box or combo box | F9 |