Keyboard Shortcuts

MS-Access 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.

Undoing Changes

 

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

Entering data in Datasheet or Form View

  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

Refreshing fields with current data

  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



Bruce Miller, 2004, 2014