Handy Access 2010 Keyboard Shortcuts

By Alison Barrows, Margaret Levine Young, Joseph C. Stockman

Part of Access 2010 All-In-One For Dummies Cheat Sheet

These keyboard shortcuts are especially useful in Access 2010. Some keystrokes work anywhere in Access 2010, while others work only in specific views, as noted.

Key or Combination Action
F1 Displays the Help window.
Ctrl+F1 Hides or displays the Ribbon.
F5 Goes to the record with the record number you type.
F6 Moves the focus to another area of the window.
F7 Checks the spelling in the selected object.
F11 Hides or displays the Navigation pane.
Delete Deletes the selected object.
Alt+Enter In Design view, displays the properties of the selected
Ctrl+C Copies the selected text or objects to the Clipboard.
Ctrl+F Finds text (with the option to replace it) in the open table,
query, or form.
Ctrl+N Starts a new database.
Ctrl+O Opens a database.
Ctrl+P Prints the selected object.
Ctrl+S Saves the selected object.
Ctrl+V Pastes the contents of the Clipboard to the active window.
Ctrl+X Deletes the selected text or object and saves it in the
Ctrl+Z Undoes the last action that can be undone (our all-time
Ctrl+; Types today’s date.
Ctrl+” Duplicates the entry from the same field in the previous
Esc Cancels what you are typing.