Microsoft Access 2019 keyboard shortcuts

Microsoft Access 2019  

defkey.com -
6 years ago
- Shortcuts

These shortcuts are valid for Microsoft Access 2016 and Microsoft Access 2013

0
Alt

or F10  Select the active tab of the ribbon and activate KeyTips

0
Alt + H

Open the Home tab

-1
F6

Move the focus to a different pane of the window

0
Ctrl + O

Open an existing database

-1
or Ctrl + F12
-2
F11

Show or hide the Navigation Pane

-2
F4

Show or hide a property sheet

1
F2

Switch between Edit mode (with insertion point displayed) and Navigation mode in a datasheet or design view

0
F5

Switch to Form view from form Design view

0
Tab

Move to the next or previous field in a Datasheet view

0
or ↑  Shift + Tab
1
F5

Go to a specific record in a Datasheet view

0
Ctrl + P

Open the Print dialog box from Print (for datasheets, forms, and reports)

0
S

Open the Page Setup dialog box (for forms and reports)

0
Z

Zoom in or out on a part of the page

0
Ctrl + F

Open the Find tab in the Find and Replace dialog box in the Datasheet view or Form view

0
Ctrl + H

Open the Replace tab in the Find and Replace dialog box in the Datasheet view or Form view

0
Ctrl + +

Add a new record in Datasheet view or Form view

0
F1

Open the Help window

0
Alt + F4

Exit Access

Advertisement

There are two ways to navigate the tabs in the ribbon:
To get to the ribbon, press Alt, and then, to move between tabs, use the Right Arrow and Left Arrow keys.
To go directly to a tab on the ribbon, press one of the following KeyTips:
0
Alt + F

Open the File page

0
Alt + H

Open the Home tab

0
Alt + C

Open the Create tab

0
Alt + X

Open the External Data tab

0
Alt + Y

Open the Database Tools tab

0
Alt + J then B

B Open the Fields tab

0
Alt + J then T

T Open the Table tab

0
Alt + X then 2

2 Open the Add-ins tab, if present

0
Alt + Q

and then enter the search term to open the Tell me box on the ribbon

0
Ctrl +   

Move between groups on a ribbon

0
Tab

Move between commands within a group

0
or ↑  Shift + Tab
You activate controls in different ways, depending upon the type of control.
If the selected command is a button, to activate it, press Spacebar or Enter.
If the selected command is a split button (that is, a button that opens a menu of additional options), to activate it, press Alt+Down Arrow. Tab through the options. To select the current option, press Spacebar or Enter.
If the selected command is a list (such as the Font list), to open the list, press the Down Arrow key. Then, to move between items, press the Up Arrow key or the Down Arrow key.
If the selected command is a gallery, to select the command, press Spacebar or Enter. Then, tab through the items.
Here is the ways to move the focus by using the keyboard:
0
Alt

Select the active tab of the ribbon and activate KeyTips

0
or F10
0

Move to a different tab

0
Tab

Move the focus to commands on the ribbon

0
or ↑  Shift + Tab
0

Move among the items on the ribbon

0
Ctrl + F1

Expand or collapse the ribbon

0
↑  Shift + F10

Display the shortcut menu for the selected item

1
F6

Move the focus to a different pane of the window

0
Tab

Move to the next or previous command on the ribbon

0
or ↑  Shift + Tab
0
Space

Activate the selected command or control on the ribbon

0
or ⤶ Enter
0
Space

Open the selected menu or gallery on the ribbon

0
or ⤶ Enter
0

Open the selected list on the ribbon, such as the Font list

0
Tab

Move between items in an open menu or gallery

Advertisement

0
⤶ Enter

Finish modifying a value in a control on the ribbon, and move the focus back to the document

0
Ctrl + N

Open a new database

0
Ctrl + O

Open an existing database

-1
or Ctrl + F12
0
⤶ Enter

Open the selected folder or file

0
Backspace

Open the folder one level above the selected folder

0
Del

Delete the selected folder or file

0
↑  Shift + F10

Display a shortcut menu for a selected item such as a folder or file

0
Tab

Move forward through options

0
↑  Shift + Tab

Move backward through options

0
F4

Open the Look in list

0
or Alt + I
0
Ctrl + S

Save a database object

0
or ↑  Shift + F12
0
F12 or Alt + F + S

Open the Save As dialog box

0
Ctrl + P

Print the current or selected object

0
P

From Print Preview, open the Print dialog box

0
or Ctrl + P
0
S

From Print Preview, open the Page Setup dialog box

0
C

or Esc  Cancel Print Preview or Layout Preview

0
Esc

From the Backstage, return to your database

By default, Access databases display as tabbed documents. To switch to windowed documents instead, on the File tab, select Options. In the Access Options dialog box, select Current Database and, under Document Window Options, select Overlapping Windows.
-1
F11

Show or hide the Navigation Pane

0
Ctrl + F

Go to the Navigation PaneSearch box (if the focus is already on the Navigation Pane)

0
F6

Switch to the next or previous pane in the workspace

0
or ↑  Shift + F6
Note: You might need to press F6 more than once; if pressing F6 doesn't display the task pane you want, press Alt to move the focus on the ribbon and then press Ctrl+Tab to move to the task pane.
0
Ctrl + F6

Switch to the next or previous database window

0
or Ctrl + ↑  Shift + F6
0
⤶ Enter

Restore the selected minimized window when all windows are minimized

0
Ctrl + F8

Turn on Resize mode for the active window when it is not maximized (press the arrow keys to resize the window, and then, to apply the new size, press Enter)

0
Ctrl + W

Close the active database window

0
or Ctrl + F4
0
Alt + F11

Switch between the Visual Basic Editor and the previous active window

0
Ctrl + F10

Maximize or restore a selected window

Working with menus, dialog boxes, wizards, and property sheets
0
Alt

or F10  Show KeyTips

0
Alt + Space

Show the program icon menu (on the program title bar), also known as the control menu

0
  

With the menu or submenu visible, select the previous or next command

0
  

Select the menu to the left or right; or, when a submenu is visible, switch between the main menu and the submenu

0
Home

Select the first or last command on the menu or submenu

0
or End
0
Space

Open the selected menu, or perform the action assigned to the selected button

0
or ⤶ Enter
0
↑  Shift + F10

Open a shortcut menu or open a drop-down menu for the selected gallery item

0
Page Up

Scroll up or down in the selected gallery list

0
or Page Down
0
Ctrl + Home

Move to the top or bottom of the selected gallery list

0
or Ctrl + End
0
Alt

Close the visible menu and submenu at the same time

0
Esc

Close the visible menu; or, with a submenu visible, close only the submenu

0
Ctrl + Tab

Switch to the next or previous tab in a dialog box

0
or Ctrl + ↑  Shift + Tab
0
Tab

Move to the next or previous option or option group

0
or ↑  Shift + Tab
0

Move between options in the selected drop-down list box, or move between options in a group of options

0
Space

Perform the action assigned to the selected button; select or clear the check box

First letter of an option in a drop-down list:  Open the list if it is closed and move to an option in the list
0
Alt + A - Z

Select the option, or select or clear the check box by the letter underlined in the option name

0
Alt +

Open the selected drop-down list box

0
Esc

Close the selected drop-down list box

0
⤶ Enter

Perform the action assigned to the default button in the dialog box

0
Esc

Cancel the command and close the dialog box

0
Tab

Toggle the focus forward between controls in the wizard

0
F6

Toggle the focus between sections (header, body, footer) of the wizard

0
Alt + N

Move to the next page of the wizard

0
Alt + B

Move to the previous page of the wizard

0
Alt + F

Complete the wizard

0
F4

Show or hide the property sheet

0
Alt + ⤶ Enter

Display a property sheet in Design view

0
  

Move among choices in the control selection drop-down list one item at a time

0
Page Down

Move among choices in the control selection drop-down list one page at a time

0
or Page Up
0
Tab

Move to the property sheet tabs from the control selection drop-down list

0
  

Move among the property sheet tabs with a tab selected, but no property selected

0
Tab

With a property already selected, move down one property on a tab

0
↑  Shift + Tab

With a property selected, move up one property on a tab; or if already at the top, move to the tab

0
Ctrl + Tab

Toggle forward between tabs when a property is selected

0
Ctrl + ↑  Shift + Tab

Toggle backward between tabs when a property is selected

0
Home

Move to the beginning of the entry

0
End

Move to the end of the entry

0
  

Move one character to the left or right

0
Ctrl +

Move one word to the left or right


Share this page on:
Is this page helpful?
0 0

Program information

Program name: Microsoft Access 2019 Microsoft Access 2019 (Productivity)

Web page: products.office.com/access

Last update: 6/24/2022 7:56 AM UTC

How easy to press shortcuts: 85%

More information >>

Updated: Added some shortcuts. (2 updates.) 7/6/2019 7:54:38 AM Updated program information.
6/24/2022 9:56:34 AM Added some shortcuts.

Shortcut count: 401

Platform detected: Windows or Linux

Similar programs




What is your favorite Microsoft Access 2019 hotkey? Do you have any useful tips for it? Let other users know below.


 
No comments yet. Ask, or type the first one!