Microsoft Access 2019 keyboard shortcuts 

Microsoft Access 2019    

Zeynel -
7 years ago
- Shortcuts
0
  

Extend a selection to adjacent rows in Datasheet view

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 among the property sheet tabs with a tab selected, but no property selected

0
  

Move one character to the left or right

0
  

Extend a selection to adjacent fields in the same row in Datasheet view

0
Alt +

Open the selected drop-down list box

0
Alt +

Open a combo box

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

Exit the subdatasheet and move to the last field of the previous record in the datasheet

0
Ctrl + ↑  Shift + Tab

Exit the subform and move to the previous field in the main form or previous record

0
Ctrl + Del

Delete all characters to the right of the insertion point

0
Ctrl + ,

Toggle forward between views when in a table, query, form, or report

0
Ctrl + Page Down

Move right one screen

0
Ctrl + Page Down

Move to the current field in the next record

0
Ctrl + Page Up

Move left one screen

0
Ctrl + Page Up

Move to the current field in the previous record

0
Ctrl + .

Toggle backward between views when in a table, query, form, or report

0
↑  Shift + F10

Display the shortcut menu for the selected item

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

Change the selection by one word to the right

0
Ctrl + ↑  Shift +

Change the size of the selection by one word to the right

0
Alt + F

Complete the wizard

0
Ctrl + ↑  Shift +

Change the selection by one word to the left

0
Ctrl + ↑  Shift +

Change the size of the selection by one word to the left

0
↑  Shift + Space

Switch between selecting the current record and the first field of the current record, in Navigation mode

0
↑  Shift + F6

Switch to the next or previous pane in the workspace

0
Ctrl + F6

Switch to the next or previous database window

0
↑  Shift + F2

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

0
Ctrl + ↑  Shift +

Collapse the subdatasheet

0
Alt + X

Open the External Data tab

0
Alt + N

Move to the next page of the wizard

0
Ctrl + ↑  Shift +

Move from the datasheet to the record's subdatasheet

0
Ctrl + F2

Invoke a Builder

0
Alt + I

Open the Look in list

0
↑  Shift + F4

Find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)

0
↑  Shift + F4

Repeat the last Find action

0
↑  Shift + End

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

0
↑  Shift + Home

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

0
↑  Shift + F7

When you have a code module open, switch from the Visual Basic Editor to form or report Design view

0
↑  Shift + F7

Switch from a control's property sheet in form or report Design view to the design surface without changing the control focus

0
Alt + Q

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

0
↑  Shift + F8

Undo the previous extension

0
↑  Shift + F9

Requery the underlying tables; in a subform, this requeries the underlying table only for the subform

0
↑  Shift + F12

Save a database object

0
Alt + B

Move to the previous page of the wizard

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)

‎-1
Ctrl + F12

Open an existing database

0
Alt + Home

Go back to Access Help Home

0
Ctrl + F10

Maximize or restore a selected window

0
Alt + F8

Invoke the Field List pane in a form, or report (if the Field List pane is already open, the focus moves to the Field List pane)

0
Alt + F8

Show or hide the Field List pane

0
Alt + Backspace

Undo typing

0
Ctrl +   

Move between groups on a ribbon

0
Alt + Space

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

0
Alt + F5

Go to a specific record in a subdatasheet

0
Alt + F5

Move to the page number box

0
Print Screen

Copy a screenshot of the entire screen to the Clipboard

Advertisement

0
Ctrl + ;

Insert the current date

0
Alt + Y

Open the Database Tools tab

0
Ctrl + '

Insert the value from the same field in the previous record

0
Alt + F11

Switch between the Visual Basic Editor and the previous active window

0
Alt + F11

Switch from the Visual Basic Editor back to form or report Design view

0
Ctrl + ↑  Shift + F6

Switch to the next or previous database window

0
Ctrl + Alt + Space

Insert the default value for a field

0
Alt + Print Screen

Copy a screenshot of the current window to the Clipboard

0
Alt + A - Z

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

0
Ctrl + ↑  Shift + :

Insert the current time

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
Ctrl + ↑  Shift + F8 then   

ht Turn on Move mode

0
F6 then ⤶ Enter

er Open the list of choices and change the connection state

0
F12 or Alt + F + S

Open the Save As dialog box

0
Tab

Move to the next or previous field in a Datasheet view

0
S

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

0
F1

Open the Help window

0
Z

Zoom in or out on a part of the page

0
F5

Switch to Form view from form Design view

1
F5

Go to a specific record in a Datasheet view

1
F2

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

0
Ctrl + F

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

0
Ctrl + O

Open an existing database

0
Ctrl + P

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

‎-2
F4

Show or hide a property sheet

‎-1
F6

Move the focus to a different pane of the window

‎-2
F11

Show or hide the Navigation Pane

0
Page Up

0
Ctrl + H

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

0
↑  Shift + Tab

Move to the next or previous field in a Datasheet view

0
Ctrl + 2

Copy the value from above row

0
Alt

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

0
Ctrl + +

Add a new record in Datasheet view or Form view

0
Alt + F4

Exit Access

0
Alt + C

Open the Create tab

0
Alt + F

Open the File page

0
Alt + H

Open the Home tab

0
or Alt + H
‎-1
Ctrl + F12

Open an existing database

0
Ctrl + Page Up / Down

Move between fields vertically

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:
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:
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.
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
Note: In order to use the Ctrl+E keyboard shortcut for opening the Edit List Items dialog box, you must have an Office 365 subscription. Currently this shortcut is only available to Insiders at this time.
Note: If multiple items are selected, pressing Spacebar affects all selected items. Select multiple items by holding down Shift while selecting them. Toggle the selected state of a single item by holding down Ctrl while selecting it.
Note: If multiple items are selected, pressing this key affects all selected items.
You can use the standard Windows editing keys when working in the SQL pane. For example, you can use Ctrl+ Arrow keys to move between words, and the Cut, Copy, and Paste commands on the Home tab work as they normally do.
Note: In Datasheet view, Extended Selection appears in the lower-right corner of the window
Note: If the insertion point is not visible, press F2 to display it.

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