ShortcutsWindows

170 MS Access Shortcut keys for Windows

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

MS Access Menu Shortcuts

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:

Related Articles

Leave a Reply

Your email address will not be published.

Back to top button