Microsoft Access 2019 keyboard shortcuts 

Microsoft Access 2019    

Zeynel -
7 years ago
- Shortcuts
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.

Advertisement

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.
Note: If additional views are available, successive keystrokes move the focus to the next available view.
Note: Ctrl+Period (.) does not work under all conditions with all objects.
0
Alt +

Move back to the previous Help topic (Back button)

0
or Backspace
0
Backspace

Delete the selection or the character to the left of the insertion point

0
Alt +

Move forward to the next Help topic (Forward button)

0
Alt + Home

Go back to Access Help Home

0
F5

Refresh the window (Refresh button)

0
Esc

Stop the last action (Stop button)

0
Esc

Cancel the command and close the dialog box

0
Esc

Close the selected drop-down list box

0
Esc

Undo changes in the current field or current record (if both the current field and current record have been changed, press Esc twice to undo changes, first in the current field and then in the current record)

0
Esc

Cancel Extend mode

0
Esc

Exit Navigation mode in a form or report

0
↑  Shift + Space

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

0
End

Move the insertion point to the end of the field, in single-line fields; or move it to the end of the line in multi-line fields

0
End

Move to the end of a line

0
End

Move to the last field in the current record

0
Home

Move to the beginning of a line

0
Home

Move the insertion point to the beginning of the field, in single-line fields; or move it to the beginning of the line in multi-line fields

0
Home

Move to the first field in the current record

0
F6

Toggle the focus between sections (header, body, footer) of the wizard

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
F6

Switch among areas in the Help window, such as the toolbar and the Search list

0
Ctrl + P

Print the current Help topic (if the cursor is not in the current Help topic, press F6, and then press Ctrl+P)

0
Ctrl + +

Add a new record

0
Ctrl + -

In a datasheet, delete the current record

0
Ctrl + C

Copy the selection to the Clipboard

0
Ctrl + X

Cut the selection and copy it to the Clipboard

0
Del

Delete the selection or the character to the right of the insertion point

0
Ctrl + V

Paste the contents of the Clipboard at the insertion point

0
Ctrl + Z

Undo typing

0
Ctrl + F

Go to the Navigation PaneSearch box (if the focus is already on the Navigation Pane)

0
Ctrl + F

Open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)

0
Ctrl +

Move up one paragraph

0
Ctrl +

Move to the current field in the first record

0
Ctrl +

Move to the current field in the last record

0
Ctrl +

Move down one paragraph

Advertisement

0
Ctrl +

Display the full set of commands on the task pane menu

0
Alt +

Open the selected drop-down list box

0
Ctrl + Home

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

0
Ctrl + Home

Move to the beginning of a text box

0
Ctrl + End

Move to the end of a text box

0
Ctrl + End

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

0
Ctrl + End

Move to the last field in the last record

0
Ctrl + Tab

Insert a tab in a cell

0
Ctrl + H

Open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only)

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

Move one character to the right

0

Move to the next field

0

Move the insertion point one character to the right

0

Move the insertion point one character to the left

0

Move to the previous field

0

Move one character to the left

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
F7

Check spelling

0
Space

Switch between the values in a check box or option button

0

Move to the next row

0

Move down one line

0

Move to the current field in the next record

0

Move to the current field in the previous record

0

Move up one line

0

Move to the preceding row

0
Ctrl +

Move one word to the left

0
Ctrl +

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

0
Ctrl +

Move the insertion point one word to the left

0
Ctrl +

Move the insertion point one word to the right

0
Ctrl +

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

0
Ctrl +

Move one word to the right

0
F2

Display the complete hyperlink address (URL) for a selected hyperlink

0
F2

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

0
Tab

Move between the upper and lower panes of the Field List

0
Tab

Select the next field

0
Tab

Toggle the focus forward between controls in the wizard

0
Tab

Select the next hidden text or hyperlink, including Show All or Hide All at the top of a topic

0
Tab

Move to the next field

0
Tab

Select the next item in the Help window

0
Tab

(at the end of the last row) Add a new row at the bottom of the table

0
Tab

Move to the next cell

0
⤶ Enter

Start a new paragraph

0
⤶ Enter

Perform the action for the selected item

0
⤶ Enter

In the AccessHelp topics list, expand or collapse the selected item

0
⤶ Enter

In a Table of Contents in tree view, expand or collapse the selected item

0
⤶ Enter

Perform the action for the selected Show All, Hide All, hidden text, or hyperlink

0
⤶ Enter

Perform the action assigned to the default button in the dialog box

0
⤶ Enter

Add the selected field to the form or report detail section

0
F1

Open the Help window

0
Alt + F4

Exit Access

0
↑  Shift + Tab

Select the previous item in the Help window

0
↑  Shift + Tab

Move to the preceding cell

0
↑  Shift + Tab

Select the previous hidden text or hyperlink

0
↑  Shift + Tab

Move to the previous field

0
F9

Recalculate the fields in the window

0
F9

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

0
Alt + F

Complete the wizard

0
Alt + N

Move to the next page of the wizard

0
F8

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

0
↑  Shift +

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

0
↑  Shift +

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

0
↑  Shift +

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

0
Page Up

Scroll larger amounts up or down, respectively within the currently displayed Help topic

0
or Page Down
0
Print Screen

Copy a screenshot of the entire screen to the Clipboard

0
Ctrl + 2

Copy the value from above row

0
Ctrl + Del

Delete all characters to the right of the insertion point

0
Alt + Backspace

Undo typing

0
Ctrl + F2

Invoke a Builder

0
Ctrl + .

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

0
Ctrl + ,

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

0
↑  Shift + F9

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

0
↑  Shift + F8

Undo the previous extension

0
  

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

0
Ctrl + ↑  Shift +

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

0
Ctrl + ↑  Shift +

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

0
  

Move up or down the Field List pane

0
  

Extend a selection to adjacent rows in Datasheet view

0
  

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

0
  

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

0
Alt + F8

Show or hide the Field List pane

0
Alt + Print Screen

Copy a screenshot of the current window to the Clipboard

0
Alt + F11

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

0
Ctrl + Alt + Space

Insert the default value for a field

0
Ctrl + '

Insert the value from the same field in the previous record

0
Ctrl + ;

Insert the current date

0
Ctrl + ↑  Shift + :

Insert the current time

0
F6 then ⤶ Enter

er Open the list of choices and change the connection state


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