Microsoft Access Shortcut keys-{200+Shortcut keys}

Microsoft Access: Microsoft access is an Information management tool that aids you to store information for future reference and analyses. Microsoft Access is a database management system, and it was developed by Microsoft Corporation. This was officially launched in November 1992. In this article, we are going to about the shortcut used in Microsoft Access Shortcut keys-{200+Shortcut keys} in detail with its explanations.

Microsoft Access
Microsoft Access

Last updated on Oct 13, 2021.

Shortcut keys for Microsoft Access Opening databases:

Shortcut keys Function
Ctrl+N This key is used to open a new database.
Ctrl+O  Use this key to open an existing database.
Alt+F4 This key is to quit Microsoft Access.

Microsoft Access Shortcut keys for printing and saving:

Shortcut keys Function
Ctrl+P Key to print the current or selected object.
Ctrl+P
P
In order to open the Print dialog box, use this key.
S  It will open the Page Setup dialog box.
C or
Esc
This key will cancel Print Preview or Layout Preview.
Ctrl+S or
Shift+F12
This key is to save a database object.
F12
Alt+f2
Use this shortcut key to open the Save As dialog box.

Microsoft Access Shortcut keys for a combo box or list box:

Shortcut keys Action
F4 Or
Alt+
Use this key to open a combo box.
F9 This key is to refresh the contents of a Lookup field.
Key to move down one line.
Page Down To move down one-page, use this key.
This key is to move up one line.
Page Up To move up one-page, use this key.
Tab This key is to exit the combo box or list box.

Microsoft Access Shortcut keys  for Datasheet view and Form view only:

Shortcut keys Action
Ctrl+F You can use this key to open the Find tab in the Find and Replace dialog box.
Ctrl+H If you want to open the Replace tab in the Find and Replace dialog box, use this key.
Shift+F4 This key is to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed.

Design View Shortcut keys:

Shortcut keys  Function
F2 In order to switch between Edit mode (with insertion point displayed) and Navigation mode
F4 For to switch to the property sheet, use this key.
F5 This key is to switch to Form view from form Design view.
F6 Use this key to switch between the upper and lower portions of a window.
F7 To switch to the Code Builder from a form or report Design view use this key.
Shift+F7 If you want to switch from the Visual Basic Editor to form or report Design view, use this key.
Alt+V+P Use this key to open the property sheet for a selected object.

Shortcut keys for Editing controls in a form and report Design view:

Shortcut key  Function
If you want to add a control to a section, use this key.
Ctrl+C In order to copy the selected control to the Clipboard, use this key.
Ctrl+X Use this key to cut the selected control and copy it to the Clipboard.
Ctrl+V This key is used to paste the contents of the Clipboard in the upper-left corner of the selected section.
Ctrl+ To move the selected control to the right, use this key.
Ctrl+  If you want to move the selected control to the left press this key.
Ctrl+ Press this key to move the selected control up.
Ctrl+ To move the selected control down, press this key.
Shift+ Use this key to increase the height of the selected control.
Shift+ This key is used to increase the width of the selected control.
Shift+ It will reduce the height of the selected control.
Shift+ It will reduce the width of the selected control.

Windows Access shortcut key for window operations:

Shortcut keys Function
F11 This key is to bring the Database window to the front.
Ctrl+F6 In order to cycle between open windows.
Enter Key to restore the selected minimized window when all windows are minimized.
Ctrl+F8 This key is used to turn on Resize mode for the active window when it’s not maximized, you have to press the arrow keys to resize the window.
Alt+Spacebar Use this key to display the Control menu.
Shift+F10 To display the shortcut menu, this key is used.
Ctrl+W
Ctrl+F4
Close the active window shortcut key.
Alt+F11 In order to switch between the Visual Basic Editor and the previously active window, press this key.
Alt+Shift+F11 To switch to the Microsoft Script Editor from the previously active window, press this key concurrently.

Windows Access shortcut key for Wizards:

Shortcut keys  Action
Tab Use this key to Move to the Help Button image button in the wizard.
Alt+N This key is to move to the next window in the wizard.
Alt+B Key to move to the previous window in the wizard.
Alt+F This key is for closing the wizard window.

Database window shortcut keys:

Editing and navigating the Object list:

Shortcut keys Action
F3 If you want to rename a selected object, use this key.
This key is used to move down one line.
Page Down  Use this key to move down one window.
End This key is used to move to the last object.
 Use this key to move up one line.
Page Up It will move up one window.
Home If you want to move to the first object, use this key.

Database window shortcut keys for Menus

Shortcut keys Action
Shift+F10 This key is to show the shortcut menu.
F10 Key to make the menu bar active.
Alt+Spacebar This key is to show the program icon menu.
Or To select the next or previous command, this key is used.
Or Use this key to select the menu to the left or right or, when a submenu is visible, to switch between the main menu and the submenu.
Home
End
Use this key to select the first or last command on the menu or submenu.
Alt For to close the visible menu and submenu at the same time.
Esc In order to close the visible menu or, with a submenu visible, to close the submenu only.

Shortcut keys for Toolbars:

Shortcut keys Action
Ctrl+Tab Use this key to select the next or previous toolbar.
Tab or Shift+Tab This key is used When a toolbar is active, to select the next or previous button or menu on the toolbar.
Enter This key is used When a menu on a toolbar is selected, to open the menu
Enter Use this key When a button is selected, to perform the action assigned to a button.

Shortcut keys for Program Windows:

Shortcut key Action
Alt+Tab or Ctrl+Shift+Tab Use this key to switch to the next program.
Alt+Shift+Tab This key is to switch to the previous program.
Ctrl+Esc Use this key to show the Windows Start menu.
Ctrl+W To close the active database window, use this key.
Ctrl+F6 If you want to switch to the next database window.
Ctrl+Shift+F6 Use this key to switch to the previous database window
Enter To restore the selected minimized window when all windows are minimized, use this shortcut key.

Shortcut keys for Dialog box:

Shortcut keys Action
Ctrl+Tab In order to switch to the next tab in a dialog box.
Ctrl+Shift+Tab If you want to switch, to the previous tab in a dialog box.
Tab This key is to move to the next option or option group.
Shift+Tab If you want to move to the previous option or option group.
←↑→↓ If you want to move between options in the selected drop-down list box or to move between some options in a group of options.
Spacebar This key is to perform the action assigned to the selected button; select or clear the checkbox.
Alt+ In order to open the selected drop-down list box.
Esc Use this key to close the selected drop-down list box.
Enter Use this key to perform the action assigned to the default button in the dialog box.
Esc In order to cancel the command and close the dialog box
Alt+F4 To close a dialog box, press this key.

Shortcut keys for Editing in a text box:

Shortcut keys Action
Home Use this key to move to the beginning of the entry.
End This key is for to move to the end of the entry.
Ctrl+ Or Ctrl+ key to move one character to the left or right.
Or In order to move one word to the left or right.
Shift+Home  If you want to select from the insertion point to the beginning of the entry.
Shift+end Use this key to select from the insertion point to the end of the entry.
Shift+ This key is to select one character to the left.
Shift+ key To select one character to the right.
Shift+ In order to To select one word to the left.
Ctrl+Shift+ To select one word to the right use this key.

Shortcut key for Work with the opening file new database, and Save dialog boxes:

Shortcut keys Action
Alt+1 To go to the Go to the previous folder use this key.
Alt+2 Use this key to open the folder up one level from the open folder.
Alt+3  In order to close the dialog box, and open your World Wide Web search page.
Alt+4 To Delete the selected folder or file
Alt+5 If you want to create a new subfolder in the open folder.
Alt+6 To Switch between List, Details, Properties, and Preview views.
Alt+7 This key is to Shows the Tools menu.

Keyboard shortcuts keys for the Help task pane:

Shortcut keys Action
F1 To Display the Help task pane.
F6 Use this key to switch between the Help task pane and the active application.
Tab This key is to select the next item in the Help task pane.
Shift+Tab Key to Select the previous item in the Help task pane.
Enter Use this key to perform the action for the selected item.
Or This key is to select the next and previous items, respectively.
Or Use this key to expand and collapse the selected item, respectively.
Alt+ Key to move back to the previous task Pane.
Alt+ Use this key to move forward to the next task Pane.
Ctrl+Spacebar This key is to open the menu of Pane options.
Ctrl+F1 Key to close and reopen the current task pane.
This key Expand a +/- list.
This key Collapse a +/- list.

Email messages shortcut keys:

Shortcut keys Action
Alt+F+D+A In order to Send the active database object as an e-mail message, this key is used.
Ctrl+Shift+B Key to Open the Address Book.
Alt+K This key is to check the names in the To, Cc, and Bcc boxes against the Address Book
Tab This key Select the next box in the e-mail header or the body of the message when the last box in the e-mail header is active.
Shift+Tab To select the previous field or button in the e-mail header.

Shortcut keys for Selecting text in a field:

Shortcut keys Action
Shift+ This key is to extend one character to the right.
Ctrl+Shift+ This key is to extend one word to the right.
Shift+ In order to extend one character to the left use this key.
Ctrl+Shift+ In order to extend one word to the left.

Shortcut keys for Selecting a field or record:

Shortcut key Action
Tab To select the next field press thus key.
F2 To switch between Edit mode (with insertion point displayed) and Navigation mode use this shortcut key method.
Shift+Spacebar If you want to switch between selecting the current record and the first field of the current record, in Navigation mode.
Shift+ This key is to extend the selection to the previous record if the current record is selected.
Shift+ It will  extend the selection to the next record if the current record is selected
Ctrl+A To select all records this key is used.
F8 Key to turn on Extend mode.
Or For to extend a selection to adjacent fields in the same row in Datasheet view.
Or If you want to extend a selection to adjacent rows in Datasheet view.
Shift+F8 Use this key to undo the previous extension.
sc Key to cancel Extend mode.

Shortcut keys for Selecting and moving a column in Datasheet view:

Shortcut keys Function
Ctrl+Spacebar If you want to select the current column or cancel the column selection, in Navigation mode.
Shift+ In order to select the column to the right, if the current column is selected.
Shift+ Use this key to select the column to the left, if the current column is selected.
Ctrl+Shift+F8 Key to turn on Move mode.

Shortcut keys for Editing text and data:

Shortcut keys Function
Ctrl+C For to copy the selection to the Clipboard.
Ctrl+X Use this key to cut the selection and copy it to the Clipboard.
Ctrl+V If you want to  paste the contents of the Clipboard at the insertion point
Backspace In order to delete the selection or the character to the left of the insertion point.
Delete In order to delete the selection or the character to the right of the insertion point.
Ctrl+Delete If you want to delete all characters to the right of the insertion point.
Ctrl+Z Undo shortcut key.
Esc Use this key to undo changes in the current field or current record if both have been changed.

Shortcut keys for entering data in Datasheet or Form view:

Shortcut keys Function
Ctrl+; Use this key to insert the current date.
Ctrl+Shift+: Key to insert the current time.
Ctrl+AltSpacebar Key to insert the default value for a field.
Ctrl+ In order to insert the value from the same field in the previous record.
Ctrl++ Use this key to add a new record.
Ctrl+ key to delete the current record.
Shift+Enter In order to save changes to the current record.
Spacebar Use this key to switch between the values in a check box or option button.
Ctrl+Enter Key to insert a new line.

Shortcut keys for Refreshing fields with current data

Shortcut keys Function
F9 If you want to recalculate the fields in the window.
Shift+F9 Use this key to restore the underlying tables.
F9 This key refreshes the contents of a Lookup field, list box, or combo box.

Verdict

Hope through this you get to know about the Microsoft Access Shortcut keys. For more details and shortcuts for apps and browsers. If you have any suggestions or questions regarding this article, let us know in the comment section, we will update it to you shortly.

Leave a Comment