Microsoft Access 2019 keyboard shortcuts 

Microsoft Access 2019    

Zeynel -
7 years ago
- Shortcuts
1
Z

Zoom in or out on a part of the page

1
↑  Shift + ⤶ Enter

Save changes to the current record

1
F2

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

1
F5

Switch to Form view from form Design view

1
F5

Go to a specific record in a Datasheet view

1
F6

Move the focus to a different pane of the window

1
Ctrl + Home

Move to the top or bottom of the selected gallery list

0
F5

Switch to Form view from form Design view

0
Ctrl + O

Open an existing database

0
Alt + B

Move to the previous page of the wizard

0
Alt + Space

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

0
Ctrl + ⤶ Enter

Insert a new line in a Short Text or Long Text field

0
F4

Show or hide the property sheet

0
Backspace

Open the folder one level above the selected folder

0
Ctrl + N

Open a new database

0
↑  Shift + F2

Open the Zoom box to conveniently enter expressions and other text in small input areas

0
Tab

Move to the next or previous option or option group

0
F6

Switch to the next or previous pane in the workspace

0
Alt + Q

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

0
Alt + C

Open the Create tab

0
⤶ Enter

Restore the selected minimized window when all windows are minimized

0
Alt + A - Z

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

0
Ctrl + Page Up / Down

Move between fields vertically

0
Z

Zoom in or out on a part of the page

0
Alt + H

Open the Home tab

0
F5

Switch to Form view from form Design view

‎-1
F11

Show or hide the Navigation Pane

‎-1
F6

Move the focus to a different pane of the window

‎-1
Ctrl + F12

Open an existing database

‎-1
or Ctrl + F12
‎-2
F4

Show or hide a property sheet

‎-2
F11

Show or hide the Navigation Pane

0
P

From Print Preview, open the Print dialog box

0
Ctrl + End

Move to the top or bottom of the selected gallery list

0
Ctrl + W

Close the active database window

0
or Ctrl + F4
0
Ctrl + Tab

Toggle forward between tabs when a property is selected

0
Ctrl + Tab

Switch to the next or previous tab in a dialog box

0
Alt + ⤶ Enter

Display a property sheet in Design view

0
Ctrl + ↑  Shift + Tab

Switch to the next or previous tab in a dialog box

0
Ctrl + ↑  Shift + Tab

Toggle backward between tabs when a property is selected

0
Ctrl + H

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

0
Space

Activate the selected command or control on the ribbon

0
Space

Open the selected menu or gallery on the ribbon

0
Space

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

0
Space

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

0

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

0
Ctrl +

Move one word to the left or right

0
or Ctrl +
0
Tab

Move to the next or previous command on the ribbon

0
Tab

Move between items in an open menu or gallery

0
Tab

Move forward through options

0
Tab

Move to the next or previous field in a Datasheet view

0
Tab

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

0
Tab

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

0
Tab

Move between commands within a group

0
Tab

Move the focus to commands on the ribbon

0
Ctrl + O

Open an existing database

0
Esc

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

Advertisement

0
Esc

From the Backstage, return to your database

0
End

Move to the end of the entry

0
End

Select the first or last command on the menu or submenu

0
or Home
0
Home

Move to the beginning of the entry

0
↑  Shift + F6

Switch to the next or previous pane in the workspace

0
Ctrl + P

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

0
Ctrl + P

From Print Preview, open the Print dialog box

0
Ctrl + P

Print the current or selected object

0
Ctrl + S

Save a database object

0
Ctrl + +

Add a new record in Datasheet view or Form view

0
Del

Delete the selected folder or file

0
Ctrl + F

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

0
F4

Open the Look in list

Advertisement

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.
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:
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:
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.
Working with menus, dialog boxes, wizards, and property sheets
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

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

0
Alt

or F10  Show KeyTips

0
Alt

Close the visible menu and submenu at the same time

0
Alt

Select the active tab of the ribbon and activate KeyTips

0
Ctrl + ↑  Shift + F6

Switch to the next or previous database window

0
  

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

0
  

Move one character to the left or right

0
  

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

0
  

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

0
  

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

0
Ctrl + F1

Expand or collapse the ribbon

0
Ctrl +   

Move between groups on a ribbon

0
Alt + F11

Switch between the Visual Basic Editor and the previous active window

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
F12 or Alt + F + S

Open the Save As dialog box

0
S

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

0
S

From Print Preview, open the Page Setup dialog box

0
Page Up

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

0
Page Up

Scroll up or down in the selected gallery list

0
or Page Down
0
Page Down

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

0
Alt + H

Open the Home tab

0
↑  Shift +

Change the selection by one character to the left

0
↑  Shift + Home

Select from the insertion point to the beginning of the text entry

0
↑  Shift + End

Select from the insertion point to the end of the text entry

0
Alt + X

Open the External Data tab

0
Alt + I

Open the Look in list

0
Alt + F

Open the File page

0
↑  Shift + F10

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

0
↑  Shift + F10

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

0
↑  Shift + F10

Display the shortcut menu for the selected item

0

Move to a different tab

0

Move among the items on the ribbon

0

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

0
↑  Shift + F12

Save a database object

0
⤶ Enter

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

0
⤶ Enter

Open the selected menu or gallery on the ribbon

0
⤶ Enter

Activate the selected command or control on the ribbon

0
⤶ Enter

Open the selected folder or file

0
⤶ Enter

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

0
F1

Open the Help window

0
Alt + F4

Exit Access

0
↑  Shift + Tab

Move between commands within a group

0
↑  Shift + Tab

Move the focus to commands on the ribbon

0
↑  Shift + Tab

Move to the next or previous option or option group

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
↑  Shift + Tab

Move backward through options

0
↑  Shift + Tab

Move to the next or previous field in a Datasheet view

0
↑  Shift + Tab

Move to the next or previous command on the ribbon

0
C

or Esc  Cancel Print Preview or Layout Preview

0
F10

Select the active tab of the ribbon and activate KeyTips

0
Ctrl + F6

Switch to the next or previous database window

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 + F10

Maximize or restore a selected window


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: 24/6/2022 7:56 AM UTC

How easy to press shortcuts: 85%

More information >>

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

Shortcut count: 401

Platform detected: Windows or Linux

Similar programs



User operations

Add Microsoft Access 2019 to your list of favorites

Advertisement


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


Only registered users can post links.
 
No comments yet. Ask, or type the first one!

Latest articles