MS Access is one of the member of Microsoft Suite Office Application. Microsoft Access is a Database Management System which stores data in its own format. Microsoft Access is just like Microsoft Excel to store and manage data. They most interesting feature of MS Access is that is manages related data more efficiently than Microsoft Excel. Check out Microsoft Excel Shortcuts.

Using this application daily to store and manage data, it is advisable to learn the MS Access shortcut keys. Learning this shortcuts will not only save your time but also can perform tasks quickly. Below are the most used MS Access Shortcut keys. You can also download it here.

Manage Databases

Action Shortcuts
Open and Create new database Ctrl + N
Open existing database Ctrl + O
Quit and Exit access Alt + F4
Print the current or selected object Ctrl + P
Save a database object Ctrl + S
Open the save as dialog box F12

Find & Replace and Wizards

Action Shortcuts
Find and replace dialog box Ctrl + F
Replace dialog box Ctrl + H
Find next Shift + F4
Go to the navigation pane search box Alt + Ctrl + F
Toggle the focus forward between controls in the wizard Tab
Move to the next page of the wizard Alt + N
Move to the previous page of the wizard Alt + B
Complete the wizard Alt + F

Form Controls

Action Shortcuts
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + P
Move selected control up
Move selected control down
Move selected control left
Move selected control Right
Increase height of the selected control Shift + ↓
Decrease height of the selected control Shift + ↑
Increase width of the selected control Shift + →
Decrease width of the selected control Shift + ←

Menus

Action Shortcuts
Show shortcut menu Shift + F10
Show the access keys Alt
Show the program icon menu Alt + Space
Select the next command in menu
Select the previous command in menu
Select the menu to the left
Select the menu to the right
Select first command in menu Home
Select last command in menu End

Dialog & Text Boxes

Action Shortcuts
Switch to next tab in a dialog box Ctrl + Tab
Switch to previous tab in a dialog box Ctrl + Shift + Tab
Move to the next option or option group Tab
Move to the previous option or option group Shift + Tab
Select current button Space
Open the selected drop-down list box Alt + ↓
Close the selected drop-down list box Esc
Cancel the command and close the dialog box Esc
Close a dialog box Alt + F4
Move beginning of an entry Home
Move to end of an entry End
Move one word to the left Ctrl + ←
Move one word to the right Ctrl + →
Select from cursor to end Shift + Home
Select from cursor to beginning Shift + End
Extend selection one character to the left Shift + ←
Extend selection one character to the right Shift + →

Select and move fields or columns

Action Shortcuts
Select next field Tab
Select previous field Shift + Tab
Select all records Ctrl + A
Turn on Extend mode F8
Undo the previous extension Shift + F8
Cancel Extend mode Esc
Select current column Ctrl + Space
Turn on Move mode Ctrl + Shift + F8

Insert Data

Action Shortcuts
Insert the current date Ctrl + ;
Insert the current time Ctrl + :
Insert the default value for a field Ctrl + Alt + Space
Insert the value from the same field in the previous record Ctrl + ‘
Add a new record Ctrl + [ + ]
In a datasheet, delete the current record Ctrl + –
Save changes to the current record Shift + Enter
Insert a new line Ctrl + Enter

Pivot Table

Action Shortcuts
Move to the right Tab
Move to the left Shift + Tab
Move down Enter
Move up Shift + Enter
Select cell above current cell Shift + Enter
Select detail cell for next item in row Ctrl + Enter
Select detail cell for previous item in row Ctrl + Shift + Enter
Expand Selection Shift + Arrow keys
Select entire Pivot Table view Ctrl + A
Display context menu Shift + F10
Display property dialog box Alt + Enter
Close property dialog box Alt + F4
Cancel refresh operation in progress Esc
Export contents to Excel Ctrl + E
Toggle expand indicators Ctrl + 8
Open list for currently selected item Alt + ↓
Toggle Autofilter Ctrl + T
Sort data ascending(A-Z) Ctrl + Shift + A
Sort data descending(Z-A) Ctrl + Shift + Z
Move selected member up Alt + Shift + ↑
Move selected member down Alt + Shift + ↓
Move selected member right Alt + Shift + →
Move selected member left Alt + Shift + ←
Display field list pane Ctrl + L
Add new total field using sum summary Ctrl + Shift + S
Add new total field using count summary Ctrl + Shift + C
Add new total field using min summary Ctrl + Shift + M
Add new total field using max summary Ctrl + Shift + X
Add new total field using average summary Ctrl + Shift + E
Add new total field using standard deviation summary Ctrl + Shift + D
Add new total field using standard deviation population summary Ctrl + Shift + T
Turn subtotals and grand totals on or off for selected field Ctrl + Shift + B
Add a calculated detail field Ctrl + F
Move selected field to row area Ctrl + 1
Move selected field to column area Ctrl + 2
Move selected field to detail area Ctrl + 4
Move selection up one level Ctrl + ←
Move selection down one level Ctrl + →
Apply the general number format to values Ctrl + Shift + ~
Apply the currency format to values Ctrl + Shift + $
Apply the percentage format to values Ctrl + Shift + %
Apply the exponential number format to values Ctrl + Shift + ^
Apply the date format to values Ctrl + Shift + #
Apply the time format Ctrl + Shift + @
Apply the numeric format Ctrl + Shift + !
Make text bold in the selected field of the PivotTable view Ctrl + B
Make text underlined in the selected field of the PivotTable view Ctrl + U
Make text italic in the selected field of the PivotTable view Ctrl + I

Manage Windows

Action Shortcuts
Toggle the Navigation Pane F11
Cycle between open windows Ctrl + F6
Display the control menu Alt + Space
Display the shortcut menu Shift + F10
Close the active window Ctrl + W
Switch between the Visual Basic Editor and the previous active window Alt + F11

Print preview and Others

Action Shortcuts
Open the print dialog box Ctrl + P
Open the page setup dialog box S
Cancel print C
Display hyperlink F2
Check spelling F7
Open the zoom box Shift + F2
Display a property sheet in Design view Alt + Enter
Invoke a builder Ctrl + F2

Knowing that it is difficult to remember all the shortcuts at once. But putting into practice daily will enhance your productivity as well as save your time and efforts. MS Access can be used by software developer to develop application software.

Hope you have liked our blog on Microsoft Access Shortcut keys. Suggestions are always welcomed for the blog you looking forward to hear from us. Like our My e-Learning Hub Facebook Page and subscribe to our My e-Learning Hub YouTube channel. Connect with us and Take your Office Productivity to Next Level.

Leave a comment

Main Office:

Andheri West, Mumbai
India

Contact Us:

hello@myelearninghub.com

MyeLearningHUB © 2019. All rights reserved.