Microsoft Access 2016

Navigating the ribbon

2 Open the Add-ins tab, if present

Alt + X then 2

All hotkeys for Microsoft Access 2016

Navigate in the Access workspace
Close the visible menu and submenu at the same time

Alt

Navigating the ribbon
Open the Home tab

Alt + H

Get help with Access
Switch among areas in the Help window, such as the toolbar and the Search list

F6

Work with database files
Open an existing database

Ctrl + O

Work with database files
Open an existing database

Ctrl + F12

Navigate in the Access workspace
Show or hide the Navigation Pane

F11

Design view: Navigating
Open or close the property sheet

F4

Miscellaneous keyboard shortcuts
Display the complete hyperlink address (URL) for a selected hyperlink

F2

Get help with Access
Refresh the window (Refresh button)

F5

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

⭾ Tab

Get help with Access
Select the previous hidden text or hyperlink

↑   Shift + ⭾ Tab

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

Ctrl + P

Form view: Navigate in Print Preview and Layout Preview
Open the Page Setup dialog box (for forms and reports)

S

Form view: Navigate in Print Preview and Layout Preview
Zoom in or out on a part of the page

Z

Find and replace text or data
Open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)

Ctrl + F

Find and replace text or data
Open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only)

Ctrl + H

Edit text or data: Enter data in a Datasheet or Form view
Add a new record

Ctrl + +

Get help with Access
Open the Help window

F1

Miscellaneous keyboard shortcuts
Exit Access

Alt + F4

Using wizards
Complete the wizard

Alt + F

Navigating the ribbon
Open the Create tab

Alt + C

Navigating the ribbon
Open the External Data tab

Alt + X

Navigating the ribbon
Open the Database Tools tab

Alt + Y

Navigating the ribbon
B Open the Fields tab

Alt + J then B

Navigating the ribbon
T Open the Table tab

Alt + J then T

Navigating the ribbon
2 Open the Add-ins tab, if present

Alt + X then 2

Navigating the ribbon
and then enter the search term to open the Tell me box on the ribbon

Alt + Q

Navigating the ribbon
Move between groups on a ribbon

Ctrl + ←  →

Navigating the ribbon
Select the active tab of the ribbon and activate KeyTips

F10

Working with panes: Using grid pane
Move among cells

← ↑ → ↓

Navigating the ribbon
Expand or collapse the ribbon

Ctrl + F1

Navigate in the Access workspace
Open a shortcut menu or open a drop-down menu for the selected gallery item

↑   Shift + F10

Edit text or data: Enter data in a Datasheet or Form view
Switch between the values in a check box or option button

Space

Get help with Access
In a Table of Contents in tree view, expand or collapse the selected item

⤶ Enter

Navigate in tables and cells: Move around in tables or cells
Move down one line

Work with database files
Open a new database

Ctrl + N

Get help with Access
Move back to the previous Help topic (Back button)

⬅ Backspace

Edit text or data: Copy, move, or delete text
Delete the selection or the character to the right of the insertion point

Del

Work with database files
Open the Look in list

Alt + I

Work with database files
Save a database object

Ctrl + S

Work with database files
Save a database object

↑   Shift + F12

Work with database files
Open the Save As dialog box

F12 or Alt + F + S

Print database information
From Print Preview, open the Print dialog box

P

Form view: Navigate in Print Preview and Layout Preview
Cancel Print Preview or Layout Preview

C

Get help with Access
Stop the last action (Stop button)

Esc

Navigate in the Access workspace
Switch to the next or previous pane in the workspace

↑   Shift + F6

Navigate in the Access workspace
Switch to the next or previous database window

Ctrl + F6

Navigate in the Access workspace
Switch to the next or previous database window

Ctrl + ↑   Shift + F6

Navigate in the Access workspace
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)

Ctrl + F8

Navigate in the Access workspace
Close the active database window

Ctrl + W

Navigate in the Access workspace
Close the active database window

Ctrl + F4

Working in a Design, Layout, or Datasheet view
Switch from the Visual Basic Editor back to form or report Design view

Alt + F11

Navigate in the Access workspace
Maximize or restore a selected window

Ctrl + F10

Navigate in the Access workspace
Show the program icon menu (on the program title bar), also known as the control menu

Alt + Space

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

↑  ↓

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

←  →

Navigate in tables and cells: Move around in tables or cells
Move to the beginning of a line

Home

Navigate in tables and cells: Move around in tables or cells
Move to the end of a line

End

Get help with Access
Scroll larger amounts up or down, respectively within the currently displayed Help topic

Page Up

Get help with Access
Scroll larger amounts up or down, respectively within the currently displayed Help topic

Page Down

Navigate in tables and cells: Move around in tables or cells
Move to the beginning of a text box

Ctrl + Home

Navigate in tables and cells: Move around in tables or cells
Move to the end of a text box

Ctrl + End

Navigate in tables and cells: Work and move around in tables
Insert a tab in a cell

Ctrl + ⭾ Tab

Form view: Navigate between a main form and a subform
Exit the subform and move to the previous field in the main form or previous record

Ctrl + ↑   Shift + ⭾ Tab

Using dialog boxes
Select the option, or select or clear the check box by the letter underlined in the option name

Alt + A - Z

Using a combo or list box
Open a combo box

Alt +

Using wizards
Move to the next page of the wizard

Alt + N

Using wizards
Move to the previous page of the wizard

Alt + B

Design view: Navigating
Open or close the property sheet

Alt + ⤶ Enter

Navigate in tables and cells: Move around in tables or cells
Move one word to the left

Ctrl +

Navigate in tables and cells: Move around in tables or cells
Move one word to the right

Ctrl +

Editing in a text box
Select from the insertion point to the beginning of the text entry

↑   Shift + Home

Editing in a text box
Select from the insertion point to the end of the text entry

↑   Shift + End

Select in a field
Change the size of the selection by one character to the left

↑   Shift +

Select in a field
Change the size of the selection by one character to the right

↑   Shift +

Select in a field
Change the size of the selection by one word to the left

Ctrl + ↑   Shift +

Select in a field
Change the size of the selection by one word to the right

Ctrl + ↑   Shift +

Edit text or data: Refresh fields with current data
Refresh the contents of a Lookup field list box or combo box

F9

Navigate in tables and cells: Move around in tables or cells
Move up one line

Using a combo or list box
Open the Edit List Items dialog box

Ctrl + E

Edit text or data: Enter data in a Datasheet or Form view
Insert a new line in a Short Text or Long Text field

Ctrl + ⤶ Enter

Navigating and opening objects
Display the Immediate window in the Visual Basic Editor

Ctrl + G

Miscellaneous keyboard shortcuts
Check spelling

F7

Working in a Design, Layout, or Datasheet view
Toggle forward between views when in a table, query, form, or report

Ctrl + ,

Working in a Design, Layout, or Datasheet view
Toggle backward between views when in a table, query, form, or report

Ctrl + .

Navigate in tables and cells: Move around in tables or cells
Move one character to the right

Navigate in tables and cells: Move around in tables or cells
Move one character to the left

Miscellaneous keyboard shortcuts
Display the full set of commands on the task pane menu

Ctrl +

Navigate in tables and cells: Move around in tables or cells
Move up one paragraph

Ctrl +

Form view: Navigate between fields and records
Move to the current field in the next record

Ctrl + Page Down

Form view: Navigate between fields and records
Move to the current field in the previous record

Ctrl + Page Up

Working with panes: Using grid pane
Select an entire grid column

Ctrl + Space

Datasheet view: Selecting and moving a column
ht Turn on Move mode

Ctrl + ↑   Shift + F8 then ←  →

Form view: Navigate in Print Preview and Layout Preview
Move to the page number box

Alt + F5

Datasheet view: Working with subdatasheets
Move from the datasheet to the record's subdatasheet

Ctrl + ↑   Shift +

Datasheet view: Working with subdatasheets
Collapse the subdatasheet

Ctrl + ↑   Shift +

Working with panes: Using Field List pane with a form or report in Design view or Layout view
Show or hide the Field List pane

Alt + F8

Design view: Navigating
Switch from a control's property sheet in form or report Design view to the design surface without changing the control focus

↑   Shift + F7

Edit text or data: Copy, move, or delete text
Copy the selection to the Clipboard

Ctrl + C

Edit text or data: Copy, move, or delete text
Cut the selection and copy it to the Clipboard

Ctrl + X

Edit text or data: Copy, move, or delete text
Paste the contents of the Clipboard at the insertion point

Ctrl + V

Select a field or record
Extend the selection to the previous record, if the current record is selected

↑   Shift +

Design view: Editing using controls in form and report
Increase the height of the selected control

↑   Shift +

Working with panes: Using diagram pane
Choose the selected data column for output

+

Working with panes: Using diagram pane
Remove the selected data column from the query output

-

Working with panes: Using grid pane
Toggle between insert and overtype mode while editing in a cell

Insert

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

↑   Shift + Space

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

F8

Extend a selection
Undo the previous extension

↑   Shift + F8

Navigate in tables and cells: Move around in tables or cells
Repeat the last Find action

↑   Shift + F4

Edit text or data: Copy, move, or delete text
Delete all characters to the right of the insertion point

Ctrl + Del

Edit text or data: Undo changes
Undo typing

Ctrl + Z

Edit text or data: Undo changes
Undo typing

Alt + ⬅ Backspace

Edit text or data: Enter data in a Datasheet or Form view
Insert the current date

Ctrl + ;

Edit text or data: Enter data in a Datasheet or Form view
Insert the current time

Ctrl + ↑   Shift + :

Edit text or data: Enter data in a Datasheet or Form view
Insert the default value for a field

Ctrl + Alt + Space

Edit text or data: Enter data in a Datasheet or Form view
Insert the value from the same field in the previous record

Ctrl + '

Edit text or data: Enter data in a Datasheet or Form view
In a datasheet, delete the current record

Ctrl + -

Edit text or data: Enter data in a Datasheet or Form view
Save changes to the current record

↑   Shift + ⤶ Enter

Edit text or data: Refresh fields with current data
Requery the underlying tables; in a subform, this requeries the underlying table only for the subform

↑   Shift + F9

Get help with Access
Go back to Access Help Home

Alt + Home

Get help with Access
Move back to the previous Help topic (Back button)

Alt +

Get help with Access
Move forward to the next Help topic (Forward button)

Alt +

Get help with Access
er Open the list of choices and change the connection state

F6 then ⤶ Enter

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

↑   Shift + F2

Miscellaneous keyboard shortcuts
Invoke a Builder

Ctrl + F2

Miscellaneous keyboard shortcuts
Copy a screenshot of the entire screen to the Clipboard

Print Screen

Miscellaneous keyboard shortcuts
Copy a screenshot of the current window to the Clipboard

Alt + Print Screen

Similar combinations for other applications