51 Shortcuts for Access 2016

Jump to: Database Operation, Windows/Content Switching/Navigation, Design/Content Operation(on selected control)

1. Database Operation

Ctrl+N	New database
Ctrl+O	Open existing database
Ctrl+S/Shift+F12	Save Database
Tab	Move to next cell
F12	Open the Save As Box
Ctrl+P	Print the current object
Ctrl+F	Open Find tab in dialog box
Ctrl+H	Open Replace tab in dialog box

2. Windows/Content Switching/Navigation

Arrow Down	Move down a line
Arrow Up	Move Up a line
PgUp	Move up a page
PgDn	Move down a page
F4	Switch to propery sheet
F2	Switch betwwn edit mode
F6	Switch windows(between upper and lower portion)
F5	Switch to form view from form design view
F7	Open VB Editor/Open the choose builder dialog box
Alt+F11	Switch from the VB editor back to form
F11	Toggle between Navigation Pane
Ctrl+F6	Cycle between windows
Enter	Restore the window
Alt+Space	Display Control Menu
ShortcutMenuKey	Display shortcut menu(key exist on right of Alt Rt)
Alt+N	Move to next page of wizard
Alt+B	MOve to previous page of wizard
Alt+F	Complete the wizard
Home	Move to beginning
End	Move to End
Ctrl+Tab	Switch to the next tab in dialog box
Ctrl+Shift+Tab	Switch to the previous tab in dialog box

3. Design/Content Operation(on selected control)

Ctrl+C	Copy
Ctrl+V	Paste
Ctrl+X	Cut
Arrow Right/Ctrl+Arrow Right	Move to Right
Arrow Left/Ctrl+Arrow Left	Move to Left
Arrow Up/Ctrl+Arrow Up	Move to Up
Arrow Down/Ctrl+Arrow Down	Move to down
Shift+Arrow Down	Increase the height
Shift+Arrow Up	Decrease the height
Shift+Arrow Right	Increase the width
Shift+Arrow Left	decrease the width
F2	Display complete hyperlink
F7	Check Spelling
Alt+Enter	Display Property sheet
Alt+F4	Exit access 16
Ctrl+F2	Invoke builder
Shift+F2	Open the zoom box
Ctrl+Z/Alt+ Bkspace	Undo
Ctrl+Delete	Delete all character to the right
F5	Move the record number box

Created by rank17 on 2/9/2017

Comment #8 by vbrat Aug 13, 2015 at 10:13 am Reply

To sort a column in datasheet view: 1. Move to the column you want to sort 2. Select the column (Ctrl + space) 3. Display the dropdown menu (Alt + down)

Comment #7 by guru Jul 14, 2015 at 03:33 am Reply

It is nice learn with excel so nice shark-at keys in hear ,,, nice ..,,

Comment #6 by Crystal Schneider Aug 19, 2014 at 10:42 am Reply

I am working in an access table entering data and the extended mode got turned on in the process of me trying to turn it off i also changed the way the entries are entered. They now all pop to the top after i unselect the row. Does any one know what iu have done?!

Comment #5 by Shannon May 5, 2014 at 08:52 pm Reply

Does anyone know, when in datasheet view of an MS access table and you have a list box of items to select from, using the keyboard how can you cycle through it? i know on a webpage you tab to the list box and use the arrow keys (up and down), however, up and down in the datasheet view goes up to the next record and vise versa?

Comment #4 by Shariff Oct 14, 2013 at 12:12 pm Reply

Thanks a lot for providing a list of detailed shortcuts for different OS environments.
It is very helpful and easy to work with using these shortcuts when you have multiple tasks to perform with less time.

Comment #3 by stutigupta Jun 18, 2013 at 06:49 am Reply

seriously its awsm.......these are very usefull ...

Comment #2 by Dilawar katawazai Jan 9, 2012 at 10:08 am Reply

Very good all the best this shurt cuts

Comment #1 by drifter Jan 2, 2012 at 08:18 pm Reply

The Access short cuts are are very comprehensive. That said, I am looking for a keyboard shortcut to select a join line between two tables within a Query Design View Diagram so that the Join Properties can be edited. Didn't see it in the current page. Any ideas?

Access Shortcuts

Advertising for Consideration:

Ads for Consideration: