List of MS Access Shortcut keys
Learn MS Access Shortcut keys for Windows
Manage Database Shortcuts
| Action |
MS Access Shortcut keys |
| Open and Create a new database |
Ctrl + N |
| Open existing database |
Ctrl + O |
| Quit and Exit access |
Alt + F4 |
| Print the selected object |
Ctrl + P |
| Save a database object |
Ctrl + S |
| Open the save as dialog box |
F12 |
| Action |
MS Access Shortcuts |
| Show shortcut menu |
Shift + F10 |
| Show the access keys |
Alt |
| Show the program icon menu |
Alt + Spacebar |
| Select the next command in the menu |
Down Arrow key |
| Select the previous command in the menu |
Up Arrow key |
| Select the menu to the left |
Left Arrow key |
| Select the menu to the right |
Right Arrow key |
| Select the first command in the menu |
Home |
| Select the last command in the menu |
End |
Form Controls Shortcuts
| Action |
Access Shortcut keys |
| Copy |
Ctrl + C |
| Paste |
Ctrl + V |
| Cut |
Ctrl + X |
| Move selected control up |
Up Arrow key |
| Move selected control down |
Down Arrow key |
| Move selected control left |
Left Arrow key |
| Move selected control Right |
Right Arrow key |
| Increase the height of the selected control |
Shift + Down Arrow key |
| Decrease height of the selected control |
Shift + Up Arrow key |
| Increase the width of the selected control |
Shift + Right Arrow key |
| Decrease width of the selected control |
Shift + Left Arrow key |
Find & Replace Shortcuts
| Action |
MS Access Shortcuts |
| Find and Replace dialog box |
Ctrl + F |
| Replace dialog box |
Ctrl + H |
| Find next |
Shift + F4 |
| Go to the navigation pane search box |
Ctrl + Alt + F |
Wizards Shortcuts
| Action |
Microsoft Access Shortcuts |
| 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 |
Dialog Shortcuts
| Action |
Microsoft Access Shortcuts |
| Switch to the next tab in a dialog box |
Ctrl + Tab |
| Switch to the 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 |
Spacebar |
| Open the selected drop-down list box |
Alt + Down Arrow key |
| Close the selected drop-down list box |
Esc |
| Cancel the command and close the dialog box |
Esc |
| Close a dialog box |
Alt + F4 |
Text Boxes Shortcuts
| Action |
Microsoft Access Shortcuts |
| Move beginning of an entry |
Home |
| Move to end of an entry |
End |
| Move one word to the left |
Ctrl + Left Arrow key |
| Move one word to the right |
Ctrl + Right Arrow key |
| Select from cursor to end |
Shift + Home |
| Select from cursor to beginning |
Shift + End |
| Extend selection one character to the left |
Shift + Left Arrow key |
| Extend selection one character to the right |
Shift + Right Arrow key |
Insert Data Shortcuts
| Action |
Microsoft Access Shortcuts |
| Insert the current date |
Ctrl + ; |
| Insert the current time |
Ctrl + : |
| Insert the default value for a field |
Ctrl + Alt + Spacebar |
| 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 |
| Recalculate the fields in the window |
F9 |
| Requery the underlying tables |
Shift + F9 |
Select and Move Fields Shortcuts
| Action |
Microsoft Access Shortcuts |
| Select next field |
Tab |
| Select previous field |
Shift + Tab |
| Switch between selecting the current record and the first field of the current record |
Shift + Spacebar |
| Extend selection to the previous record |
Shift + Up Arrow key |
| Extend selection to next record |
Shift + Down Arrow key |
| Select all records |
Ctrl + A |
| Turn on Extend mode |
F8 |
| Undo the previous extension |
Shift + F8 |
| Cancel Extend mode |
Esc |
| Select the current column |
Ctrl + Spacebar |
| Turn on Move mode |
Ctrl + Shift + F8 |
Manage Window Shortcuts
| Action |
Microsoft Access Shortcuts |
| Toggle the Navigation Pane |
F11 |
| Cycle between open windows |
Ctrl + F6 |
| Restore the selected minimized window |
Enter |
| Turn on Resize mode for the active window when it is not maximized |
Ctrl + F8 |
| Display the control menu |
Alt + Spacebar |
| Display the shortcut menu |
Shift + F10 |
| Close the active window |
Ctrl + F4 |
| Switch between the Visual Basic Editor |
Alt + F11 |
Print Preview Shortcuts
| Action |
Microsoft Access Shortcuts |
| Open the Print dialog box |
Ctrl + P |
| Open the page setup dialog box |
S |
| Cancel print or layout preview |
C |
Design View Shortcuts
| Action |
Microsoft Access Shortcuts |
| Switch between Edit and Navigation mode |
F2 |
| Toggle the property sheet |
F4 |
| Switch to Form view from form Design view |
F5 |
| Switch between the windows |
F6 |
| Open the Visual Basic Editor from a selected property |
F7 |
| Invokes the Field List pane in a form, report, or data access page |
Alt + F8 |
| Switch to Form or Report Design View |
Shift + F7 |
| Display a property sheet |
Alt + Enter |
| Increase the height of the selected control |
Shift + Down Arrow key |
| Decrease height of the selected control |
Shift + Up Arrow key |
| Increase the width of the selected control |
Shift + Right Arrow key |
| Decrease width of the selected control |
Shift + Left Arrow key |
Navigation Shortcuts for Datasheet, Subdatasheet etc.
| Action |
Microsoft Access Shortcuts |
| Move to the record number box |
F5 |
| Move to next field in the current record |
Tab |
| Move to the previous field in the current record |
Shift + Tab |
| Move to the first field in the current record |
Home |
| Move to the last field in the current record |
End |
| Move to the next record |
Down Arrow key |
| Move to the previous record |
Up Arrow key |
| Move to the last record |
Ctrl + Down Arrow key |
| Move to the first record |
Ctrl + Up Arrow key |
| Move to the first field in the first record |
Ctrl + Home |
| Move to the last field in the last record |
Ctrl + End |
| Move down one screen |
Page Down key |
| Move up one screen |
Page Up key |
| Move right one screen |
Ctrl + Page Down key |
| Move left one screen |
Ctrl + Page Up key |
| Move from subdatasheet to record number box |
Alt + F5 |
| In subdatasheet: Exit to next record |
Ctrl + Tab |
| In subdatasheet: Exit to the previous record |
Ctrl + Shift + Tab |
| Expand subdatasheet |
Ctrl + Shift + Down Arrow key |
| Collapse subdatasheet |
Ctrl + Shift + Up Arrow key |
Pivot Table Shortcuts
| Action |
Microsoft Access Shortcuts |
| Make text bold |
Ctrl + B |
| Make text underlined |
Ctrl + U |
| Make text italic |
Ctrl + I |
| Move to the right |
Tab |
| Move to the left |
Shift + Tab |
| Move down |
Enter |
| Move up |
Shift + Enter |
| Select cell above the current cell |
Shift + Enter |
| Select detail cell for next item in the row |
Ctrl + Enter |
| Select detail cell for the previous item in the row |
Ctrl + Shift + Enter |
| Select entire PivotTable 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 |
| Expand selected item |
Ctrl + + |
| Collapse current item |
Ctrl + – |
| Open list for the currently selected item |
Alt + Down Arrow key |
| Toggle AutoFilter |
Ctrl + T |
| Move selected member up |
Alt + Shift + Up Arrow key |
| Move selected member down |
Alt + Shift + Down Arrow key |
| Move selected member right |
Alt + Shift + Right Arrow key |
| Move selected member left |
Alt + Shift + Left Arrow key |
| Display Field List pane |
Ctrl + L |
| Sort data ascending (A-Z) |
Ctrl + Shift + A |
| Sort data descending (Z-A) |
Ctrl + Shift + Z |
| 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 |
| 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 + ! |
| Add a calculated detail field |
Ctrl + F |
| Move the selected field to the row area |
Ctrl + 1 |
| Move the selected field to the column area |
Ctrl + 2 |
| Move the selected field to the filter area |
Ctrl + 3 |
| Move the selected field to detailed area |
Ctrl + 4 |
| Move selection up one level |
Ctrl + Left Arrow key |
| Move selection down one level |
Ctrl + Right Arrow key |
Others Shortcuts
| Action |
Microsoft Access Shortcuts |
| 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 |
Download MS Access Shortcut keys PDF
Download MS Access Shortcut keys PDF
READ NEXT:
