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

Move one word to the left or right

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

Change the selection by one character to the left

0
↑  Shift +

Change the selection by one character to the right

0
Ctrl + ↑  Shift +

Change the selection by one word to the left

0
Ctrl + ↑  Shift +

Change the selection by one word to the right

Advertisement

0
F4

Open a combo box

0
or Alt +
0
F9

Refresh the contents of a Lookup field list box or combo box

0

Move down one line

0
Page Down

Move down one page

0

Move up one line

0
Tab

Exit the combo box or list box

0
Ctrl + E

Open the Edit List Items dialog box

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.
0
F2

Rename a selected object

Note: F2 works only when the object is closed.
0

Move down one line

0
Page Down

Move down one window

0
End

Move to the last object

0

Move up one line

0
Page Up

Move up one window

0
⤶ Enter

Open the selected table or query in Datasheet view

0
⤶ Enter

Open the selected form or report

0
⤶ Enter

Run the selected macro

0
Ctrl + ⤶ Enter

Open the selected table, query, form, report, macro, or module in Design view

0
Ctrl + G

Display the Immediate window in the Visual Basic Editor

0
F2

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

0
Esc

Exit Navigation mode and return to Edit mode in a form or report

0
F4

Switch to the property sheet (Design view and Layout view in forms and reports)

0
or Alt + ⤶ Enter
0
F5

Switch to Form view from form Design view

0
F6

Switch between the upper and lower portions of a window (Design view of queries, macros, and the Advanced Filter/Sort window)

0
F6

Cycle through the field grid, property sheet, field properties, the Navigation Pane, Quick Access Toolbar, and KeyTips on the ribbon (Design view of tables)

0
F7

Open the Choose Builder dialog box from a selected control on a form or report (Design view only)

0
F7

Open the Visual Basic Editor from a selected property in the property sheet for a form or report

0
Alt + F11

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

0
Ctrl +

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

0
or Ctrl + ,
Note: If additional views are available, successive keystrokes move the focus to the next available view.
0
Ctrl +

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

0
or Ctrl + .
Note: Ctrl+Period (.) does not work under all conditions with all objects.
0
Tab

Move to the next field

0
or
0
End

Move to the last field in the current record

0
↑  Shift + Tab

Move to the previous field

0
or
0
Home

Move to the first field in the current record

0

Move to the current field in the next record

0
Ctrl +

Move to the current field in the last record

0
Ctrl + End

Move to the last field in the last record

Advertisement

0

Move to the current field in the previous record

0
Ctrl +

Move to the current field in the first record

0
Ctrl + Home

Move to the first field in the first record

0
F5

(then, in the record number box, type the record number and press Enter) Go to a specific record

0
Page Down

Move up one screen

0
Page Up

Move down one screen

0
Ctrl + Page Down

Move right one screen

0
Ctrl + Page Up

Move left one screen

0
Ctrl + Space

Select the current column or cancel the column selection, in Navigation mode only

0
↑  Shift +

Extend the selection one column to the right, if the current column is selected

0
↑  Shift +

Extend the selection one column to the left, if the current column is selected

0
Ctrl + ↑  Shift + F8 then   

ht Turn on Move mode

0
Tab

Enter the subdatasheet from the last field of the previous record in the datasheet

0
↑  Shift + Tab

Enter the subdatasheet from the first field of the following record in the datasheet

0
Ctrl + Tab

Exit the subdatasheet and move to the first field of the next record in the datasheet

0
Ctrl + ↑  Shift + Tab

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

0
Tab

From the last field in the subdatasheet enter the next field in the datasheet

0

From the datasheet, bypass the subdatasheet and move to the next record in the datasheet

0

From the datasheet, bypass the subdatasheet and move to the previous record in the datasheet

0
Alt + F5

Go to a specific record in a subdatasheet

Note: This moves the focus from the subdatasheet to the record number box.
0
Ctrl + ↑  Shift +

Move from the datasheet to the record's subdatasheet

0
Ctrl + ↑  Shift +

Collapse the subdatasheet

Note: To navigate between fields and records in a subdatasheet, use the same keyboard shortcuts you use in Datasheet view.
0
F2

Switch between Edit mode (with insertion point displayed) and Navigation mode

0
F4

Open or close the property sheet

0
or Alt + ⤶ Enter
1
F5

Switch to Form view from form Design view

0
F6

Switch between the upper and lower portions of a window (Design view of queries, macros, and the Advanced Filter/Sort window)

Note: Use F6 when the Tab key does not take you to the section of the screen you want.
0
F6

Toggle forward between the design pane, properties, Navigation Pane, ribbon, and Zoom controls (Design view of tables, forms, and reports)

0
F7

Open the Visual Basic Editor from a selected property in the property sheet for a form or report

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

Copy the selected control to the Clipboard

0
Ctrl + X

Cut the selected control and copy it to the Clipboard

0
Ctrl + V

Paste the contents of the Clipboard in the upper-left corner of the selected section

0

Move the selected control to the right by a pixel along the page's grid

0

Move the selected control to the left by a pixel along the page's grid

0

Move the selected control up by a pixel along the page's grid

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.
0

Move the selected control down by a pixel along the page's grid

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.
0
Ctrl +

Move the selected control to the right by a pixel (irrespective of the page's grid)

0
Ctrl +

Move the selected control to the left by a pixel (irrespective of the page's grid)

0
Ctrl +

Move the selected control up by a pixel (irrespective of the page's grid)

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.
0
Ctrl +

Move the selected control down by a pixel (irrespective of the page's grid)

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.
0
↑  Shift +

Increase the width of the selected control (to the right) by a pixel

Note: For controls in a stacked layout, this increases the width of the whole layout.
0
↑  Shift +

Decrease the width of the selected control (to the left) by a pixel

Note: For controls in a stacked layout, this decreases the width of the whole layout.
0
↑  Shift +

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

0
↑  Shift +

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

0
Ctrl + C

Copy the selected control to the Clipboard

0
Ctrl + X

Cut the selected control and copy it to the Clipboard

0
Ctrl + V

Paste the contents of the Clipboard in the upper-left corner of the selected section

0

Move the selected control to the right (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments) Move the selected control to the right (except a control that is part of a layout)

0

Move the selected control to the left (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments)  Move the selected control to the left (except a control that is part of a layout)

0

Move the selected control up (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments)  Move the selected control up (except a control that is part of a layout)

0

Move the selected control down (except a control that is part of a layout)

0
Ctrl +

(Move in smaller increments) Move the selected control down (except a control that is part of a layout)

0
↑  Shift +

Increase the height of the selected control

Note: If used with a control that is in a layout, the entire row of the layout is resized.
0
↑  Shift +

Increase the width of the selected control

Note: If used with a control that is in a layout, the entire column of the layout is resized.
0
↑  Shift +

Reduce the height of the selected control

Note: If used with a control that is in a layout, the entire row of the layout is resized.
0
↑  Shift +

Reduce the width of the selected control

Note: If used with a control that is in a layout, the entire column of the layout is resized.
0
Tab

Move to the next field

0
↑  Shift + Tab

Move to the previous field

0
End

Move to the last control on the form and remain in the current record

0
Ctrl + End

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

0
Home

Move to the first control on the form and remain in the current record

0
Ctrl + Home

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

0
Ctrl + Page Down

Move to the current field in the next record


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



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.


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