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

Move to the current field in the previous record

0
F5

Go to a specific record

Advertisement

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
Tab

Enter the subform from the preceding field in the main form

0
↑  Shift + Tab

Enter the subform from the following field in the main form

0
Ctrl + Tab

Exit the subform and move to the next field in the master form or next record

0
Ctrl + ↑  Shift + Tab

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

0
Ctrl + P

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

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

Move to the bottom of the page

0

Scroll up in small increments

0
Page Up

Scroll up one full screen

0
Ctrl +

Move to the top of the page

0

Scroll to the right in small increments

0
End

Move to the right edge of the page

0
Ctrl + End

Move to the lower-right corner of the page

0

Scroll to the left in small increments

0
Home

Move to the left edge of the page

0
Ctrl + Home

Move to the upper-left corner of the page

0
Alt + F5

Move to the page number box

0
Tab

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

0
or ↑  Shift + Tab
0

Move between columns in a table, view, or function

0
Space

Choose the selected data column for output

0
or +
0
Space

Remove the selected data column from the query output

0
or -
0
Del

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

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

Move among cells

0
or Tab
0
or ↑  Shift + Tab
0
Ctrl +

Move to the last row in the current column

0
Ctrl +

Move to the first row in the current column

0
Ctrl + Home

Move to the upper-left cell in the visible portion of grid

0
Ctrl + End

Move to the bottom right cell

0

Move in a drop-down list

0
or
0
Ctrl + Space

Select an entire grid column

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

Note: If multiple items are selected, pressing this key affects all selected items.
0
Del

Clear the selected contents of a cell

0
Del

Clear all values for a selected grid column

Advertisement

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.
0
Alt + F8

Show or hide the Field List pane

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

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

0
↑  Shift +

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

0
↑  Shift +

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

0
Ctrl + ↑  Shift +

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

0
↑  Shift +

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

0
Ctrl + ↑  Shift +

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

0
F8

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

Note: In Datasheet view, Extended Selection appears in the lower-right corner of the window
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
↑  Shift + F8

Undo the previous extension

0
Esc

Cancel Extend mode

0
Ctrl + F

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

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)

Note: If the insertion point is not visible, press F2 to display it.
0

Move the insertion point one character to the right

0
Ctrl +

Move the insertion point one word to the right

0

Move the insertion point one character to the left

0
Ctrl +

Move the insertion point one word to the left

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

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

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

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

0
Ctrl + C

Copy the selection to the Clipboard

0
Ctrl + X

Cut the selection and copy it to the Clipboard

0
Ctrl + V

Paste the contents of the Clipboard at the insertion point

0
Backspace

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

0
Del

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

0
Ctrl + Del

Delete all characters to the right of the insertion point

0
Ctrl + Z

Undo typing

0
or Alt + Backspace
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
Ctrl + ;

Insert the current date

0
Ctrl + ↑  Shift + :

Insert the current time

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

Add a new record

0
Ctrl + -

In a datasheet, delete the current record

1
↑  Shift + ⤶ Enter

Save changes to the current record

0
Space

Switch between the values in a check box or option button

0
Ctrl + ⤶ Enter

Insert a new line in a Short Text or Long Text field

0
F9

Recalculate the fields in the window

0
↑  Shift + F9

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

0
F9

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

0
Tab

Move to the next cell

0
↑  Shift + Tab

Move to the preceding cell

0

Move to the next row

0

Move to the preceding row

0
Ctrl + Tab

Insert a tab in a cell

0
⤶ Enter

Start a new paragraph

0
Tab

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

0

Move one character to the left

0

Move one character to the right

0

Move up one line

0

Move down one line

0
Ctrl +

Move one word to the left

0
Ctrl +

Move one word to the right

0
End

Move to the end of a line

0
Home

Move to the beginning of a line

0
Ctrl +

Move up one paragraph

0
Ctrl +

Move down one paragraph

0
Ctrl + End

Move to the end of a text box

0
Ctrl + Home

Move to the beginning of a text box

0
↑  Shift + F4

Repeat the last Find action

0
F1

Open the Help window

0
Alt + Home

Go back to Access Help Home

0
Tab

Select the next item in the Help window

0
↑  Shift + Tab

Select the previous item in the Help window


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!