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 object | Ctrl+P |
Save a database object | Ctrl S |
Open the save as dialog box | F12 |
Find & Replace dialog box | Ctrl + F |
Replace dialog box Ctrl | Ctrl +H |
Find next | Shift + F4 |
Go to Navigation pane search box | Alt+Ctrl+F |
Cut | Ctrl+X |
Copy | Ctrl+C |
Paste | Ctrl+V |
Move selected control | UP AERO |
Move selected control | Down AERO |
Move selected control | left AERO |
Move selected control | right AERO |
Increase height of the selected control | Shift + Down AERO |
Decrease height of the selected control | Shift + UP AERO |
Increase width of the selected control | Shift + Right AERO |
Decrease width of the selected control | Shift + Left AERO |
Show shortcut menu | Shift + F10 |
Show the access keys | Alt + |
Show the program icon menu | Alt +Space |
Select the next command in menu | Down AERO |
Select the previous command in menu | UP AERO |
Select the menu to the left | Left AERO |
Select the menu to the right | Right AERO |
Select first command in menu | Home |
Select last command in menu | END |
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 | Tab |
Move to the previous option | Shift +Tab |
Select current button | Space |
Open the selected drop-down list box | Alt Down AERO |
Close the selected drop-down list box | Esc |
Move beginning of an entry | Home |
Move to end of an entry | End |
Move one word to the left | Ctrl + Left AERO |
Select from cursor to end | Shift + Home |
Select from cursor to beginning | Shift + END |
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 |
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 | Ctrl Shift F8 |
nsert the current date | Ctrl ; |
Insert the current date | Ctrl : |
Insert the default value for a fiel | Ctrl Alt Space |
Insert the value from the same field | 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 |
Move to the right | Tab |
Move to the left | Shift TAB |
Move down | Enter |
Move up | Shift enter |
Switch between two window | Alt F11 |
Close the active window | Ctrl W |
Display the shortcut menu | Shift F10 |
Display the control menu | Alt Space |
Cycle between open windows | Ctrl F6 |
Toggle the navigation pane | F11 |
Make text italic | Ctrl I |
Make text underlined | Ctrl U |
Make text bold | Ctrl B |
Apply the numeric format | Ctrl Shift ! |
Apply the time format | Ctrl Shift @ |
Apply the date format to values | Ctrl Shift # |
Apply the exponential number format | Ctrl Shift ^ |
Apply the percentage format to values | Ctrl Shift % |
Apply the currency format to values | Ctrl Shift $ |
Apply the general number format | Ctrl Shift ~ |
Move selected field to detail area | Ctrl 4 |
Move selected field to column area | Ctr 2 |
Move selected field to row area | Ctrl 1 |
Add calculated detail field | Ctrl F |
Turn subtotals & grand totals on/off | Ctrl Shift B |
Standard deviation population summary | Ctrl Shif T |
Standard deviation summary | Ctrl Shift +D |
Add new total field using average summary | Ctrl Shift +E |
Add new total field using max summary | Ctrl Shift+ X |
Add new total field using min summary | Ctrt Shift+ M |
Add new total field using count summary | Ctrl Shift C |
Add new total field using sum summary | Ctrl Shift +S |