MS Access : All Shortcut Keys

General Shortcuts

Shortcut Keys	Functions
F1	Display the Microsoft Access Help, This may be context-sensitive help depending on what you are positioned on
F11	Display the Database window
F12	Open the Save As dialog box
CTRL+N	Open a new database
CTRL+O	Open an existing database
CTRL+P	Print the current or selected object
CTRL+S	Save the current database object
CTRL+W	Close the active window
ALT+SPACEBAR	Display the Control menu
ALT+F11	Toggle between the Visual Basic editor and the Access Database window
SHIFT+F10	Display the shortcut menu (ie: popup menu)

Database

Shortcut Keys	Functions
Ctrl+N	Open/create new database
Ctrl+O	Open existing database
Alt+F4	Quit/ exit Access
Ctrl+P	Print the current or selected object
Ctrl+S	Save a database object (or Shift+f12)
F12	Open the Save As dialog box

Download our Android App Best Computer Guide 



Navigation Keys

Shortcut Keys	Functions
Ctrl+Tab/Ctrl+Shift+Tab	Switch to next tab / switch to previous tab in a dialog box
Tab/Shift+Tab	Move to the next / switch to previous option or option group
Arrow Keys	Move between options
Space	Select current button
Alt+Arrow Down	Open the selected drop-down list box
Esc	Close the selected drop-down list box
Enter	Perform the action assigned to the default button in the dialog box
Esc	Cancel the command and close the dialog box
Alt+F4	Close a dialog box
Home/End	Move beginning / move to end of an entry
Ctrl+Arrow Left/Ctrl+Arrow Right	Move one word to the left or right
Shift+Home/Shift+End	Select from cursor to end / to beginning
Shift+Arrow Left/Shift+Arrow Right	Extend selection one character to the left / to the right
Tab/Shift+Tab	Select next field / select previous field
Shift+Space	Switch between selecting the current record and the first field of the current record
Shift+Arrow Up/Shift+Arrow Down	Extend selection to previous record/ to next record
Ctrl+A	Select all records (or Ctrl+Shift+Space)
F8	Turn on Extend mode
Arrow Left/Arrow Right	Extend a selection to adjacent fields in the same row in Datasheet view
Arrow Up/Arrow Down	Extend a selection to adjacent rows in Datasheet view
Shift+F8	Undo the previous extension
Esc	Cancel Extend mode
Ctrl+Space	Select the current column
Shift+Arrow Right/Shift+Arrow Left	Select the column to the right / to the left, if the current column is selected
Ctrl+Shift+F8	Turn on Move mode
F5	Move to the record number box, type in number and press enter
Tab/Shift+Tab	Move to next / move to previous field in current record
Home/End	Move to first / move to last field in current record
Arrow Down/Arrow Up	Move to next / move to previous record
Ctrl+Arrow Down/Ctrl+Arrow Up	Move to last record / move to first record (or current field in next record / in previous record when in subdatasheet)
Ctrl+Home/Ctrl+End	Move to first field in first record / last field in last record
Page Down/Page Up	Move down one screen / move up one screen
Ctrl+Page Down/Ctrl+Page Up	Move right one screen / left one screen
Ctrl+Tab/Ctrl+Shift+Tab	In subdatasheet: Exit to next / to previous record
Ctrl+Shift+Arrow Down	Expand subdatasheet
Ctrl+Shift+Arrow Up	Collapse subdatasheet
Alt+F5	Move from subdatasheet to record number box, enter record number and press enter

Others

Shortcut Keys	Functions
F11	Toggle the Navigation Pane
Ctrl+F6	Cycle between open windows
Enter	Restore the selected minimized window when all windows are minimized
Ctrl+F8	Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window
Alt+Space	Display the control menu
Shift+F10	Display the shortcut menu
Ctrl+W/Ctrl+F4	Close the active window
Alt+F11	Switch between the Visual Basic Editor and the previous active window
Ctrl+P	Open the Print dialog box (or p)
S	Open the page setup dialog box
C	Cancel print/ layout preview (or escape)
Tab/Shift+Tab	Go to next / go to previous text or hyperlink
Enter	Perform action for currently selected item
Alt+Arrow Left/Alt+Arrow Right	Move back / move forward
Ctrl+P	Open the Print dialog box
Arrow Up/Arrow Down	Move up / move down in small increments
Page Up/Page Down	Move up / move down one one page
Shift+F10	Show context menu
F2	Display hyperlink
F7	Check spelling
Shift+F2	Open the Zoom box
Alt+Enter	Display a property sheet in Design view
Ctrl+F2	Invoke a Builder
Ctrl+Arrow Right/Ctrl+Arrow Left	Toggle forward / toggle backwards between views when in a table, or other elements