Microsoft Access 2019 keyboard shortcuts 

Microsoft Access 2019    

Zeynel -
7 years ago
- Shortcuts
0
Home

Move to the left edge of the page

0

Scroll to the right in small increments

0
End

Move to the right edge of the page

0
Tab

Move among tables, views, and functions (and join lines, if available)

0
Space

Remove the selected data column from the query output

0

Move between columns in a table, view, or function

0
Space

Choose the selected data column for output

0

Move among cells

0
or Tab
0

Scroll up in small increments

0
Page Up

Scroll up one full screen

0
Tab

Enter the subform from the preceding field in the main form

0
Page Down

Move down one page; at the end of the record, moves to the equivalent page on the next record

0
Page Up

Move up one page; at the end of the record, moves to the equivalent page on the previous record

0
S

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

1
Z

Zoom in or out on a part of the page

0
C

Cancel Print Preview or Layout Preview

0
or Esc
0

Scroll down in small increments

0
Page Down

Scroll down one full screen

0
Del

Remove the selected table, view, or function, or join line from the query

0
Del

Clear the selected contents of a cell

0
Del

Clear all values for a selected grid column

0
⤶ Enter

Add the selected field to the form or report detail section

0
  

Move up or down the Field List pane

0
Tab

Move between the upper and lower panes of the Field List

0
F2

Toggle between Edit mode and cell selection mode

0
Ctrl + C

Copy selected text in cell to the Clipboard (in Edit mode)

0
Ctrl + X

Cut selected text in cell and place it on the Clipboard (in Edit mode)

0
Ctrl + V

Paste text from the Clipboard (in Edit mode)

0
Insert

Toggle between insert and overtype mode while editing in a cell

0
Space

Toggle the check box in the Output column

0

Move in a drop-down list

0
or
0
Tab

Select the next field

0
F2

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

0
Esc

Exit Navigation mode in a form or report

0
  

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

0
  

Extend a selection to adjacent rows in Datasheet view

0
F8

Turn on Extend mode (repeatedly pressing F8 extends the selection to the word, the field, the record, and all records)

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

Move among the items on the ribbon

0
Ctrl + F1

Expand or collapse the ribbon

0
Alt + Y

Open the Database Tools 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

0
⤶ Enter

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

0
Ctrl + S

Save a database object

0
F4

Open the Look in list

0
P

From Print Preview, open the Print dialog box

0
Tab

Move forward through options

0
Del

Delete the selected folder or file

0
⤶ Enter

Open the selected folder or file

0
Ctrl + N

Open a new database

Advertisement

0
Tab

Move between commands within a group

0
Alt + H

Open the Home tab

0
F10

Select the active tab of the ribbon and activate KeyTips

0

Move to a different tab

0
Tab

Move the focus to commands on the ribbon

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

Open the Home tab

‎−1
F6

Move the focus to a different pane of the window

0
F1

Open the Help window

1
F5

Go to a specific record in a Datasheet view

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

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

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

0
F4

Show or hide the property sheet

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

Move to the next or previous option or option group

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
Page Up

Scroll up or down in the selected gallery list

0
or Page Down
0
Esc

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

0
Ctrl + W

Close the active database window

0
or Ctrl + F4
0
⤶ Enter

Restore the selected minimized window when all windows are minimized

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

‎−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

Move the selected control down (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

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

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
Tab

Move to the next field

0
F5

Go to a specific record

0
Home

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

0
End

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

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

0
F2

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

0
F4

Open or close the property sheet

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)

0

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

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
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
Tab

Enter the subdatasheet from 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
Tab

Move to the next field

0
or
0
End

Move to the last field in the current record

0

Move to the current field in the previous 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: 1401/4/3 7:56 UTC

How easy to press shortcuts: 85%

More information >>

Updated: Added some shortcuts. (2 updates.) 1398/4/15 5:54:38 Updated program information.
1401/4/3 7: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