Master the MS Access shortcut keys first and then explore more learning resources in order to uplift your access skills. Working with data in MS Access will keep your hands always attached to the MS Access Shortcut keys. This will cut down the time and effort that you put to manage, analyze and make reports in MS Access.
Much like other Microsoft Office applications, Microsoft Access too is packed with MS Access shortcut keys designed specially to boost your productivity. It will also reduce your manual search and operational time. The ultimate list of MS Access Shortcut keys is what you will find below. Download the MS Access shortcut keys in the form of a PDF.
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 |
Read More: 20 Zendesk Shortcuts You Should Know
| 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 the selected control up |
Up Arrow key |
| Move the selected control down |
Down Arrow key |
| Move the 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 the height of the selected control |
Shift + Up Arrow key |
| Increase the width of the selected control |
Shift + Right Arrow key |
| Decrease the width of the selected control |
Shift + Left Arrow key |
Read More: 80 Apple Numbers Shortcuts for Mac
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 |
Read More: 50 Mastercam Shortcuts for Windows
Text Boxes Shortcuts
| Action |
Microsoft Access Shortcuts |
| Move the beginning of an entry |
Home |
| Move to the 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 the cursor to beginning |
Shift + End |
| Extend the selection of one character to the left |
Shift + Left Arrow key |
| Extend the selection of 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 |
Read More: 80 Apple Keynote Shortcuts for Mac
Select and Move Fields Shortcuts
| Action |
Microsoft Access Shortcuts |
| Select next field |
Tab |
| Select the 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 the height of the selected control |
Shift + Up Arrow key |
| Increase the width of the selected control |
Shift + Right Arrow key |
| Decrease the 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 the 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 sub datasheet to record number box |
Alt + F5 |
| In sub datasheet: Exit to next record |
Ctrl + Tab |
| In sub datasheet: Exit to the previous record |
Ctrl + Shift + Tab |
| Expand sub datasheet |
Ctrl + Shift + Down Arrow key |
| Collapse sub datasheet |
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 the cell above the current cell |
Shift + Enter |
| Select the detail cell for the next item in the row |
Ctrl + Enter |
| Select the detail cell for the previous item in the row |
Ctrl + Shift + Enter |
| Select the entire PivotTable View |
Ctrl + A |
| Display context menu |
Shift + F10 |
| Display property dialog box |
Alt + Enter |
| Close the 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 members 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 a new total field using the count summary |
Ctrl + Shift + C |
| Add new total field using min summary |
Ctrl + Shift + M |
| Add a new total field using the 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 the 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 to spell |
F7 |
| Open the Zoom box |
Shift + F2 |
| Display a property sheet in the Design view |
Alt + Enter |
| Invoke a Builder |
Ctrl + F2 |
Despite the rise in free database software, Microsoft Access still ranks in the top 10. It is very rare to find great database software other than MS Access. LibreOffice Base is a worthy Microsoft Access Alternative. Dig yourself through the LibreOffice Base shortcuts list.
FAQs
What is Microsoft Access?
Microsoft Access is a relational database management system (RDBMS) developed by Microsoft. It is part of the Microsoft Office suite and provides tools for creating, managing, and analyzing databases.
What are some commonly used Microsoft Access shortcut keys?
Here are a few commonly used shortcut keys in Microsoft Access:
- Ctrl + N: Create a new database or object.
- Ctrl + O: Open an existing database.
- Ctrl + S: Save the current database or object.
- Ctrl + C: Copy the selected text or object.
- Ctrl + V: Paste copied or cut text or object.
- Ctrl + Z: Undo the last action.
- Ctrl + Y: Redo the last undone action.
- Ctrl + F: Open the Find dialog to search for specific data.
- F5: Refresh the data in a table or form.
- F11: Open the Database Window (Navigation Pane).
Are there any specific shortcut keys for navigating within MS Access forms or reports?
Yes, there are specific shortcut keys for navigating within MS Access forms and reports. Some common ones include:
- Tab: Move to the next control in the tab order.
- Shift + Tab: Move to the previous control in the tab order.
- Enter: Move to the next record (when in a form or datasheet view).
- Shift + Enter: Move to the previous record (when in a form or datasheet view).
- Ctrl + Home: Move to the first record.
- Ctrl + End: Move to the last record.
READ NEXT:
