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
|