Do you use MS Access Shortcut keys? MS Access is one of the members of the Microsoft Suite Office Application. Microsoft Access is a Database Management System that stores data in its own format. Microsoft Access is just like Microsoft Excel to store and manage data. The most interesting feature of MS Access is that it manages related data more efficiently than Microsoft Excel. Check out Microsoft Excel Shortcuts.
Summary
MS Access Shortcut keys you Should know
Using this application daily to store and manage data, it is advisable to learn the MS Access shortcut keys. Learning these shortcuts will not only save your time but also can perform tasks quickly. Below are the most used MS Access Shortcut keys. Download MS Access Shortcut Keys PDF
Download MS Access Shortcut Keys PDF
Manage Databases
Action | Shortcut keys |
---|---|
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 |
Read More: 150+ Outlook Shortcuts – Download Outlook Keyboard Shortcuts PDF
Find & Replace and Wizards
Action | Shortcut keys |
---|---|
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 | Shortcut keys |
---|---|
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 + ← |
Read More: 90+ Wordpad shortcut keys – Download Wordpad Shortcuts PDF
Menus Shortcuts
Action | Shortcut Keys |
---|---|
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 | Shortcut Keys |
---|---|
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 | Shortcut keys |
---|---|
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 |
Read More: 120+ Microsoft OneNote Shortcuts – Download OneNote Shortcuts PDF
Insert Data
Action | Shortcut Keys |
---|---|
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 | Shortcut Keys |
---|---|
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 | Shortcut Keys |
---|---|
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 | Shortcut Keys |
---|---|
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 |
Read more
Top 15 Tips & Tricks of Google Sheets
Technical Analysis vs Fundamental Analysis
List of All Adobe Acrobat Shortcuts for Windows and Mac
150+ Windows keyboard Shortcuts to boost your productivity
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 MS Access Shortcut keys. Suggestions are always welcomed for the blog you looking forward to hear from us. Connect with us and Take your Office Productivity to Next Level.