Microsoft Access 2019 keyboard shortcuts 

Microsoft Access 2019    

Zeynel -
7 years ago
- Shortcuts
0
↑  Shift +

Extend the selection to the previous record, if the current record is selected

0
Ctrl + End

Move the insertion point to the end of the field, in multi-line fields

0
Ctrl + End

Move to the last control on the form and set focus in the last record

0
Ctrl + End

Move to the lower-right corner of the page

0
Ctrl + End

Move to the bottom right cell

0
Ctrl + End

Move to the end of a text box

0
↑  Shift +

Increase the height of the selected control

0
↑  Shift +

Increase the height of the selected control (from the bottom) by a pixel

0
Ctrl + End

Move to the last field in the last record

0
Ctrl + End

Move to the top or bottom of the selected gallery list

0
Insert

Toggle between insert and overtype mode while editing in a cell

0
Alt + F4

Exit Access

0
or Alt + F4
0
Ctrl + F4

Close the active database window

0
  

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

0
  

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

0
  

In a Table of Contents in tree view, select the previous or next item, respectively

0
  

Scroll small amounts up or down within the currently displayed Help topic

0
  

Move up or down the Field List pane

0
  

Extend a selection to adjacent rows in Datasheet view

0
  

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

0
  

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

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

Open a combo box

0
Alt +

Open the selected drop-down list 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
Alt + C

Open the Create tab

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 to the current field in the previous record

0
Ctrl + Page Up

Move left one screen

0
Ctrl + .

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

0
Ctrl + ↑  Shift +

Change the selection by one word to the right

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 size of the selection by one word to the right

0
Ctrl + ↑  Shift +

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

0
Alt + F

Complete the wizard

0
Alt + F

Open the File page

0
Ctrl + ↑  Shift +

Change 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 + F2

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

0
Ctrl + F6

Switch to the next or previous database window

0
↑  Shift + F6

Switch to the next or previous pane in the workspace

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

Repeat the last Find action

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)

Advertisement

0
Ctrl + F1

Expand or collapse the ribbon

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
Alt + H

Open the Home tab

0
or Alt + H
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

-1
or Ctrl + F12
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

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
Ctrl + Page Up / Down

Move between fields vertically

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
F6 then ⤶ Enter

er Open the list of choices and change the connection state

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

Advertisement

Note: This moves the focus from the subdatasheet to the record number box.
Note: To navigate between fields and records in a subdatasheet, use the same keyboard shortcuts you use in Datasheet view.
Note: Use F6 when the Tab key does not take you to the section of the screen you want.
Note: For controls in a stacked layout, this switches the position of the selected control with the control directly below it, unless it is already the lowermost control in the layout.
Note: For controls in a stacked layout, this switches the position of the selected control with the control directly above it, unless it is already the uppermost control in the layout.
Note: For controls in a stacked layout, this switches the position of the selected control with the control directly above it, unless it is already the uppermost control in the layout.
Note: For controls in a stacked layout, this increases the width of the whole layout.
Note: For controls in a stacked layout, this switches the position of the selected control with the control directly below it, unless it is already the lowermost control in the layout.
Note: For controls in a stacked layout, this decreases the width of the whole layout.
Note: If used with a control that is in a layout, the entire row of the layout is resized.
Note: If used with a control that is in a layout, the entire row of the layout is resized.
Note: If used with a control that is in a layout, the entire column of the layout is resized.
Note: If used with a control that is in a layout, the entire column of the layout is resized.
Note: Ctrl+Period (.) does not work under all conditions with all objects.
Note: If additional views are available, successive keystrokes move the focus to the next available view.
Note: F2 works only when the object is closed.
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.
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:
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
Working with menus, dialog boxes, wizards, and property sheets
0
F12 or Alt + F + S

Open the Save As dialog box


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/06/2022 07.56 UTC

How easy to press shortcuts: 85%

More information >>

Updated: Added some shortcuts. (2 updates.) 06/07/2019 05.54.38 Updated program information.
24/06/2022 07.56.34 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