Microsoft Access Shortcut Keys

MS Access is one of the members of the Microsoft Suite Office Application.  Microsoft Access is just like Microsoft Excel to store and manage data. Using this Software daily to store and manage data, it is advisable to learn the Microsoft Access shortcut keys. Learning these shortcuts will not only save your time but also can perform tasks quickly. Below are the most used Microsoft Access Shortcut Keys

Microsoft Access Shortcut Keys

Open existing database Ctrl+O
Quit and Exit access Alt F4
Print the current objectCtrl+P
Save a database objectCtrl S
Open the save as dialog boxF12
Find & Replace dialog boxCtrl + F
Replace dialog box CtrlCtrl +H
Find nextShift + F4
Go to Navigation pane search boxAlt+Ctrl+F
CutCtrl+X
CopyCtrl+C
PasteCtrl+V
Move selected controlUP AERO
Move selected controlDown AERO
Move selected controlleft AERO
Move selected controlright AERO
Increase height of the selected controlShift + Down AERO
Decrease height of the selected controlShift + UP AERO
Increase width of the selected controlShift + Right AERO
Decrease width of the selected controlShift + Left  AERO
Show shortcut menuShift + F10
Show the access keysAlt  +  
Show the program icon menuAlt  +Space
Select the next command in menuDown AERO
Select the previous command in menuUP AERO
Select the menu to the leftLeft  AERO
Select the menu to the right Right AERO
Select first command in menuHome
Select last command in menuEND
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 optionTab
Move to the previous optionShift +Tab
Select current buttonSpace
Open the selected drop-down list boxAlt Down AERO
Close the selected drop-down list boxEsc
Move beginning of an entryHome
Move to end of an entryEnd
Move one word to the leftCtrl  + Left AERO
Select from cursor to endShift + Home
Select from cursor to beginningShift + END
Move to the next page of the wizardAlt N
Move to the previous page of the wizardAlt B
Complete the wizardAlt F
Select next fieldTab
Select previous fieldShift TAB
Select all recordsCtrl  A
Turn on extend modeF8
Undo the previous extensionShift F8
Cancel Extend modeEsc
Select current columnCtrl Space
Turn on move mode CtrlCtrl Shift F8
nsert the current dateCtrl ;
Insert the current dateCtrl :
Insert the default value for a fielCtrl Alt Space
Insert the value from the same fieldCtrl ‘
Add a new record Ctrl []
In a datasheet, delete the current recordCtrl –
Save changes to the current recordShift Enter
Insert a new lineCtrl Enter
Move to the rightTab
Move to the leftShift TAB
Move downEnter
Move upShift enter
Switch between two windowAlt F11
Close the active windowCtrl W
Display the shortcut menuShift F10
Display the control menuAlt  Space
Cycle between open windowsCtrl  F6
Toggle the navigation paneF11
Make text italicCtrl I
Make text underlinedCtrl U
Make text boldCtrl B
Apply the numeric formatCtrl Shift !
Apply the time formatCtrl Shift  @
Apply the date format to valuesCtrl Shift   #
Apply the exponential number formatCtrl Shift ^
Apply the percentage format to valuesCtrl Shift %
Apply the currency format to valuesCtrl Shift $
Apply the general number formatCtrl Shift ~
Move selected field to detail areaCtrl 4
Move selected field to column areaCtr 2
Move selected field to row areaCtrl 1
Add calculated detail fieldCtrl F
Turn subtotals & grand totals on/offCtrl Shift   B
Standard deviation population summaryCtrl Shif T
Standard deviation summaryCtrl Shift +D
Add new total field using average summaryCtrl Shift +E
Add new total field using max summaryCtrl Shift+ X
Add new total field using min summaryCtrt Shift+ M
Add new total field using count summaryCtrl Shift C
Add new total field using sum summaryCtrl Shift +S