Access 2013 keyboard shortcuts
This section provides a
comprehensive list of keyboard shortcuts built into Access 2013. The list has
been excerpted from Access Help and formatted in tables for convenient lookup.
Open, save, and print
databases
Action
|
Keyboard shortcut
|
Display
the New page of the Backstage view.
|
Ctrl+N
|
Display
the Open page of the Backstage view.
|
Ctrl+O
|
Open the Save As dialog box
for an unsaved object, or save a
previously saved object.
|
Ctrl+S
or Shift+F12
|
Open
the Save As dialog box.
|
F12
|
Open
the Print dialog box.
|
Ctrl+P
|
Open
the Print dialog box from Print Preview.
|
P or
Ctrl+P
|
Open
the Page Setup dialog box from Print Preview.
|
S
|
Cancel
Print Preview or Layout Preview.
|
C or
Esc
|
Work in Design, Layout, or
Datasheet view
Action
|
Keyboard shortcut
|
Cycle
between open objects.
|
Ctrl+F6
|
Close
the active object.
|
Ctrl+W
or Ctrl+F4
|
Display
the Property Sheet pane in Design view.
|
Alt+Enter
|
Open or close the Property
Sheet pane (form or report Design view
and Layout view).
|
F4
|
Switch
to Form view from form Design view.
|
F5
|
Cycle
through the upper and lower parts of the Query Designer,
Navigation
pane, access keys in the Keyboard Access System, and Zoom controls (query
Design view, and the Advanced Filter/Sort window).
|
F6
|
Cycle
through the field grid, field properties, Navigation pane, access keys in the
Keyboard Access System, Zoom controls, and the security bar (table Design
view).
|
F6
|
Open
the Choose Builder dialog box (form or report Design view).
|
F7
|
Open
the Expression Builder dialog box (query Design view).
|
Ctrl+F2
|
Open the Zoom box to enter
expressions and other text in small input
areas.
|
Shift+F2
|
Open
the Visual Basic Editor from a selected property in the Property Sheet pane
(form or report).
|
F7
|
Switch
from the Visual Basic Editor to form or report Design view.
|
Alt+F11
|
Work in the Navigation pane
Action
|
Keyboard shortcut
|
Open
or close the Navigation pane
|
F11
|
Open
the selected database object.
|
Enter
|
Run
the selected macro.
|
Enter
|
Open the selected table,
query, form, report, macro, or module
in Design view.
|
Ctrl+Enter
|
Display
the Immediate window in the Visual Basic Editor.
|
Ctrl+G
|
Move
up or down one line.
|
Up
Arrow or Down Arrow
|
Move
up or down one window.
|
Page
Up or Page Down
|
Move
to the last object.
|
End
|
Rename
a selected object.
|
F2
|
With
the Navigation pane active, display its Search box.
|
Ctrl+F
|
Work in the Property Sheet
pane
Action
|
Keyboard shortcut
|
Open
or close the Property Sheet pane (Design or Layout view).
|
F4
|
Move among choices in the
control drop-down list one item at a
time.
|
Down
Arrow or Up Arrow
|
Move among choices in the
control drop-down list one page at a
time.
|
Page
Down or Page Up
|
Move
to the Property Sheet tabs from the control drop-down list.
|
Tab
|
Move
among the Property Sheet tabs with a tab selected, but no property selected.
|
Left
Arrow or Right Arrow
|
With
a property selected, move down one property on a tab.
|
Tab
|
With
a property selected, move up one property on a tab; or if already at the top, move to the tab.
|
Shift+Tab
|
Toggle
forward or backward between tabs when a property is selected.
|
Ctrl+Tab
or Ctrl+Shift+Tab
|
Work in the Field List pane
Action
|
Keyboard shortcut
|
Open
or close the Field List pane.
|
Alt+F8
|
Add
the selected field to the form or report detail section.
|
Enter
|
Move
up or down the Field List pane.
|
Up
Arrow or Down Arrow
|
Move
between Fields Available lists in the Field List pane.
|
Tab
|
Edit controls in forms or
reports in Design view
Action
|
Keyboard shortcut
|
Copy
the selected control to the Clipboard.
|
Ctrl+C
|
Cut
the selected control and copy it to the Clipboard.
|
Ctrl+X
|
Paste the contents of the
Clipboard in the upper-left corner of
the selected section.
|
Ctrl+V
|
Move the selected control
to the right (except controls that are
part of a layout).
|
Right
Arrow or
Ctrl+Right
Arrow
|
Move the selected control
to the left (except controls that are
part of a layout).
|
Left
Arrow or
Ctrl+Left
Arrow
|
Action
|
Keyboard shortcut
|
Move the selected control
up (except controls that are part of a
layout).
|
Up
Arrow or Ctrl+Up Arrow
|
Move the selected control
down (except controls that are part of
a layout).
|
Down
Arrow or
Ctrl+Down
Arrow
|
Increase
or reduce the height of the selected control.
|
Shift+Down
Arrow or
Shift+Up
Arrow
|
Increase or reduce the
width of the selected control. (If used
with controls that are in a layout, the entire layout is resized.)
|
Shift+Right
Arrow or
Shift+Left
Arrow
|
Work with combo boxes or
list boxes
Action
|
Keyboard shortcut
|
Open
a combo box.
|
F4 or
Alt+Down Arrow
|
Refresh
the contents of a Lookup field list box or combo box.
|
F9
|
Move
up or down one line.
|
Up
Arrow or Down Arrow
|
Move
up or down one page.
|
Page
Up or Page Down
|
Exit
the combo box or list box.
|
Tab
|
Set properties for a table
in Design view
Action
|
Keyboard shortcut
|
Move from the field grid to
the field properties area.
Pressing F6 continuously
also activates the Navigation pane, access
keys in the Keyboard Access System, Zoom controls, and the security bar.
|
F6
|
With a tab selected, but no
property selected, move between the
General and Lookup tabs.
|
Left
Arrow or Right Arrow
|
Move
between the tabs when a property is selected.
|
Ctrl+Tab
|
Move
to the first property of a tab when no property is selected.
|
Tab
|
Move
down one property on a tab.
|
Tab
|
Move up one property on a
tab; or if already at the top, select
the tab itself.
|
Shift+Tab
|
Work with text and data
TIP Although many of these keyboard shortcuts also work
in other Office programs, they are gathered here for convenience.
Select
text in a field
Action
|
Keyboard shortcut
|
Change
the size of the selection by one character to the right.
|
Shift+Right
Arrow
|
Change
the size of the selection by one word to the right.
|
Ctrl+Shift+Right
Arrow
|
Change
the size of the selection by one character to the left.
|
Shift+Left
Arrow
|
Change
the size of the selection by one word to the left.
|
Ctrl+Shift+Left
Arrow
|
Select a field or record
TIP To cancel a selection, use the opposite Arrow key.
|
|
Action
|
Keyboard shortcut
|
Select
the next field.
|
Tab
|
Select
all records.
|
Ctrl+A
or
Ctrl+Shift+Spacebar
|
Extend
a selection
|
|
Action
|
Keyboard shortcut
|
Extend selection from the
current record to the previous or next
record when Extend mode is not turned on.
|
Shift+Up
Arrow or
Shift+Down
Arrow
|
Extend selection from the
current column to the previous or next
column when Extend mode is not turned on.
|
Shift+Left
Arrow or
Shift+Right
Arrow
|
Turn on Extend mode;
pressing F8 repeatedly extends the
selection to the word, the field, the record, and all records.
|
F8
|
In Extend mode, extend a
selection to adjacent fields in the
same row in Datasheet view.
|
Left
Arrow or Right Arrow
|
In Extend mode, extend a
selection to adjacent rows in
Datasheet view.
|
Up
Arrow or Down Arrow
|
Undo
the previous extension.
|
Shift+F8
|
Cancel
Extend mode.
|
Esc
|
Move a
column in Datasheet view
Action
|
Keyboard shortcut
|
Turn
on Move mode.
|
Ctrl+Shift+F8
|
Move
selected column(s) to the right or left in Move mode.
|
Right
Arrow or Left Arrow
|
Move
the cursor in a field
|
|
Action
|
Keyboard shortcut
|
Move
the cursor one character to the right or left.
|
Right
Arrow or Left Arrow
|
Move
the cursor one word to the right or left.
|
Ctrl+Right
Arrow or
Ctrl+Left
Arrow
|
Move the cursor to the end
of the field, in single-line fields;
or move it to the end of the line in multiple-line fields.
|
End
|
Move
the cursor to the end of the field, in multiple-line fields.
|
Ctrl+End
|
Move the cursor to the
beginning of the field, in single-line fields; or move it to the beginning of the line in
multiple-line fields.
|
Home
|
Move
the cursor to the beginning of the field, in multiple-line fields.
|
Ctrl+Home
|
Enter
data in Datasheet or Form view
|
|
Action
|
Keyboard shortcut
|
Insert
the current date.
|
Ctrl+Semicolon
(;)
|
Insert
the current time.
|
Ctrl+Shift+Colon
(:)
|
Insert
the default value for a field.
|
Ctrl+Alt+Spacebar
|
Insert
the value from the same field in the previous record.
|
Ctrl+Apostrophe
(‘)
|
Add a
new record.
|
Ctrl+Plus
Sign (+)
|
In a
datasheet, delete the current record.
|
Ctrl+Minus
Sign (-)
|
Save
changes to the current record.
|
Shift+Enter
|
Switch
between the values in a check box or option button.
|
Spacebar
|
Insert
a new line in a Short Text or Long Text field.
|
Ctrl+Enter
|
Undo
changes in the current field or current record; if both have been changed, press Esc twice to undo
changes, first in the current field and then in the current record.
|
Esc
|
Refresh
fields with current data
Action
|
Keyboard shortcut
|
Recalculate
the fields in the window.
|
F9
|
Requery the underlying
tables; in a subform, this requires the
underlying table for the subform only.
|
Shift+F9
|
Refresh
the contents of a Lookup field list box or combo box.
|
F9
|
Find and replace text or data (Datasheet view or Form
view)
Action
|
Keyboard shortcut
|
Open
the Find tab in the Find And Replace dialog box.
|
Ctrl+F
|
Open
the Replace tab in the Find And Replace dialog box.
|
Ctrl+H
|
Find the next occurrence of
the text specified in the Find And
Replace dialog box when the dialog box is closed.
|
Shift+F4
|
Navigate records
Navigate in Design view
Action
|
Keyboard shortcut
|
Switch between Edit mode (with cursor displayed) and Navigation mode.
|
F2
|
Switch to Form view from form Design view.
|
F5
|
Cycle through the upper and lower parts of the Query Designer,
Navigation pane, access keys in the Keyboard Access System, and Zoom controls (query Design view, and the Advanced Filter/Sort window).
|
F6
|
Cycle through the field grid, field properties, Navigation pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (table Design view).
|
F6
|
Open the Visual Basic Editor from a selected property in the Property Sheet pane for a form or report.
|
F7
|
Open or close the Field List pane in a form or report.
|
Alt+F8
|
Switch from the Property Sheet pane to the design grid without changing the selected control ( form or report Design view).
|
Shift+F7
|
Navigate in Datasheet view
Navigate between fields and records
Action
|
Keyboard shortcut
|
Move to the next field.
|
Tab or Right Arrow
|
Move to the previous field.
|
Shift+Tab or Left Arrow
|
Move to the first or last field in the current record, in Navigation mode.
|
Home or End
|
Move to the current field in the previous or next record.
|
Up Arrow or Down Arrow
|
Move to the current field in the last record, in Navigation mode.
|
Ctrl+Down Arrow
|
Move to the last field in the last record, in Navigation mode.
|
Ctrl+End
|
Move to the current field in the first record, in Navigation mode.
|
Ctrl+Up Arrow
|
Move to the first field in the first record, in Navigation mode.
|
Ctrl+Home
|
Navigate to another screen of data
| |
Action
|
Keyboard shortcut
|
Move up or down one screen.
|
Page Up or Page Down
|
Move left or right one screen.
|
Ctrl+Page Up or
Ctrl+Page Down
|
Navigate in subdatasheets
TIP You can navigate between fields and records in a subdatasheet with the same shortcut keys used in Datasheet view.
Action
|
Keyboard shortcut
|
Move from the datasheet to expand the record’s subdatasheet.
|
Ctrl+Shift+Down Arrow
|
Collapse the subdatasheet.
|
Ctrl+Shift+Up Arrow
|
Enter the subdatasheet from the last field of the previous record in the datasheet.
|
Tab
|
Enter the subdatasheet from the first field of the following record in the datasheet.
|
Shift+Tab
|
Exit the subdatasheet and move to the first field of the next record in the datasheet.
|
Ctrl+Tab
|
Exit the subdatasheet and move to the last field of the previous record in the datasheet.
|
Ctrl+Shift+Tab
|
Action
|
Keyboard shortcut
|
From the last field in the subdatasheet to enter the next field in the datasheet.
|
Tab
|
From the datasheet to bypass the subdatasheet and move to the next record in the datasheet.
|
Down Arrow
|
From the datasheet to bypass the subdatasheet and move to the previous record in the datasheet.
|
Up Arrow
|
Navigate in Form view
Navigate between fields and records
Action
|
Keyboard shortcut
|
Move to the next or previous field.
|
Tab or Shift+Tab
|
Move to the last control on the form and remain in the current record, in Navigation mode.
|
End
|
Move to the last control on the form and set focus in the last record, in Navigation mode.
|
Ctrl+End
|
Move to the first control on the form and remain in the current record, in Navigation mode.
|
Home
|
Move to the first control on the form and set focus in the first record, in Navigation mode.
|
Ctrl+Home
|
Move to the current field in the previous or next record.
|
Ctrl+Page Up or
Ctrl+Page Down
|
Navigate in forms with more than one page
| |
Action
|
Keyboard shortcut
|
Move down one page; at the end of the record, moves to the equivalent page on the next record.
|
Page Down
|
Move up one page; at the end of the record, moves to the equivalent page on the previous record.
|
Page Up
|
Navigate in Print Preview
Action
|
Keyboard shortcut
|
Open the Print dialog box from the Print page of the Backstage view, or from datasheets, forms, and reports.
|
Ctrl+P
|
Open the Page Setup dialog box (forms and reports only).
|
S
|
Zoom in or out on a part of the page.
|
Z
|
View the next page (when Fit To Window is selected).
|
Page Down or
Down Arrow
|
View the previous page (when Fit To Window is selected).
|
Page Up or Up Arrow
|
Move to the page number box.
Then enter the page number, and press Enter.
|
Alt+F5
|
Scroll up or down in small increments.
|
Up Arrow or
Down Arrow
|
Scroll up or down one full screen.
|
Page Up or Page Down
|
Move to the top or bottom of the page.
|
Ctrl+Up Arrow or
Ctrl+Down Arrow
|
Scroll to the left or right in small increments.
|
Left Arrow or
Right Arrow
|
Move to the left or right edge of the page.
|
Home or End
|
Move to the upper-left or upper-right corner of the page.
|
Ctrl+Home or Ctrl+End
|
Cancel Print Preview.
|
C or Esc
|
Navigate in the Query Designer
Action
|
Keyboard shortcut
|
Move among the Query Designer panes.
|
F6 or Shift+F6
|
Navigate in the top pane
TIP If multiple items are selected, pressing the Spacebar affects all selected items. Select multiple items by holding down the Shift key while clicking them. Toggle the selected state of a single item by holding down the Ctrl key while clicking it.
Action
|
Keyboard shortcut
|
Move among tables, views, and functions, (and to join lines, if available).
|
Tab or Shift+Tab
|
Move between columns in a table, view, or function.
|
Arrow keys
|
Choose the selected data column for output.
|
Spacebar or Plus key
|
Remove the selected data column from the query output.
|
Spacebar or Minus key
|
Remove the selected table, view, or function, or join line from the query.
|
Delete
|
Navigate in the query design grid
| |
Action
|
Keyboard shortcut
|
Move among cells.
|
Arrow keys or Tab or
Shift+Tab
|
Move to the last row in the current column.
|
Ctrl+Down Arrow
|
Move to the first row in the current column.
|
Ctrl+Up Arrow
|
Move to the upper-left cell in the visible portion of the grid.
|
Ctrl+Home
|
Move to the lower-right cell.
|
Ctrl+End
|
Move in a drop-down list.
|
Up Arrow or
Down Arrow
|
Select an entire grid column.
|
Ctrl+Spacebar
|
Toggle between edit mode and cell selection mode.
|
F2
|
Toggle between insert and overstrike mode while editing in a cell.
|
Ins
|
Toggle the check box in the Show column. (If multiple items are selected, pressing this key affects all selected items.)
|
Spacebar
|
Clear the selected contents of a cell.
|
Delete
|
Navigate in the SQL pane
You can use the standard Windows editing keys when working in the SQL pane, such as Ctrl+Arrow keys to move between words, and the Cut, Copy, and Paste commands on the Home tab.
TIP You can only insert text; there is no overstrike mode.
Access web app keyboard shortcuts
Use the following keyboard shortcuts while working with Access web apps.
Customize a web app in Access
TIP Many of the shortcuts listed earlier in “Access 2013 keyboard shortcuts” are also available when customizing a web app.
Action
|
Keyboard shortcut
|
Advance through all tables and views (when not in Edit mode).
|
Tab
|
Move a table or view selector.
|
Arrow keys
|
Show or hide the Navigation pane.
|
F11
|
Advance through the controls in a view (when in Edit mode).
|
Tab
|
Move the selected control(s).
|
Arrow keys
|
Open or close the properties for the selected control.
|
F4
|
Show or hide the Field List.
|
Alt+F8
|
Work with a web app in a web browser
TIP You can also use any keyboard shortcut keys that are provided by the browser itself.
Action
|
Keyboard shortcut
|
Move between the table list, view selector, action bar, search box, and controls in views
|
Tab, Shift+Tab, or
Arrow keys
|
Create a new item.
|
N
|
Delete an item.
|
Delete
|
Edit an item.
|
E
|
Save an item.
|
Ctrl+S
|
Cancel an action.
|
Escape
|
Edit a filter.
|
/
|
Close a popup view.
|
Escape
|
Navigate records
Navigate in Design view
Action
|
Keyboard shortcut
|
Switch between Edit mode (with cursor displayed) and Navigation mode.
|
F2
|
Switch to Form view from form Design view.
|
F5
|
Cycle through the upper and lower parts of the Query Designer,
Navigation pane, access keys in the Keyboard Access System, and Zoom controls (query Design view, and the Advanced Filter/Sort window).
|
F6
|
Cycle through the field grid, field properties, Navigation pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (table Design view).
|
F6
|
Open the Visual Basic Editor from a selected property in the Property Sheet pane for a form or report.
|
F7
|
Open or close the Field List pane in a form or report.
|
Alt+F8
|
Switch from the Property Sheet pane to the design grid without changing the selected control ( form or report Design view).
|
Shift+F7
|
Navigate in Datasheet view
Navigate between fields and records
Action
|
Keyboard shortcut
|
Move to the next field.
|
Tab or Right Arrow
|
Move to the previous field.
|
Shift+Tab or Left Arrow
|
Move to the first or last field in the current record, in Navigation mode.
|
Home or End
|
Move to the current field in the previous or next record.
|
Up Arrow or Down Arrow
|
Move to the current field in the last record, in Navigation mode.
|
Ctrl+Down Arrow
|
Move to the last field in the last record, in Navigation mode.
|
Ctrl+End
|
Move to the current field in the first record, in Navigation mode.
|
Ctrl+Up Arrow
|
Move to the first field in the first record, in Navigation mode.
|
Ctrl+Home
|
Navigate to another screen of data
| |
Action
|
Keyboard shortcut
|
Move up or down one screen.
|
Page Up or Page Down
|
Move left or right one screen.
|
Ctrl+Page Up or
Ctrl+Page Down
|
Navigate in subdatasheets
TIP You can navigate between fields and records in a subdatasheet with the same shortcut keys used in Datasheet view.
Action
|
Keyboard shortcut
|
Move from the datasheet to expand the record’s subdatasheet.
|
Ctrl+Shift+Down Arrow
|
Collapse the subdatasheet.
|
Ctrl+Shift+Up Arrow
|
Enter the subdatasheet from the last field of the previous record in the datasheet.
|
Tab
|
Enter the subdatasheet from the first field of the following record in the datasheet.
|
Shift+Tab
|
Exit the subdatasheet and move to the first field of the next record in the datasheet.
|
Ctrl+Tab
|
Exit the subdatasheet and move to the last field of the previous record in the datasheet.
|
Ctrl+Shift+Tab
|
Action
|
Keyboard shortcut
|
From the last field in the subdatasheet to enter the next field in the datasheet.
|
Tab
|
From the datasheet to bypass the subdatasheet and move to the next record in the datasheet.
|
Down Arrow
|
From the datasheet to bypass the subdatasheet and move to the previous record in the datasheet.
|
Up Arrow
|
Navigate in Form view
Navigate between fields and records
Action
|
Keyboard shortcut
|
Move to the next or previous field.
|
Tab or Shift+Tab
|
Move to the last control on the form and remain in the current record, in Navigation mode.
|
End
|
Move to the last control on the form and set focus in the last record, in Navigation mode.
|
Ctrl+End
|
Move to the first control on the form and remain in the current record, in Navigation mode.
|
Home
|
Move to the first control on the form and set focus in the first record, in Navigation mode.
|
Ctrl+Home
|
Move to the current field in the previous or next record.
|
Ctrl+Page Up or
Ctrl+Page Down
|
Navigate in forms with more than one page
| |
Action
|
Keyboard shortcut
|
Move down one page; at the end of the record, moves to the equivalent page on the next record.
|
Page Down
|
Move up one page; at the end of the record, moves to the equivalent page on the previous record.
|
Page Up
|
Navigate in Print Preview
Action
|
Keyboard shortcut
|
Open the Print dialog box from the Print page of the Backstage view, or from datasheets, forms, and reports.
|
Ctrl+P
|
Open the Page Setup dialog box (forms and reports only).
|
S
|
Zoom in or out on a part of the page.
|
Z
|
View the next page (when Fit To Window is selected).
|
Page Down or
Down Arrow
|
View the previous page (when Fit To Window is selected).
|
Page Up or Up Arrow
|
Move to the page number box.
Then enter the page number, and press Enter.
|
Alt+F5
|
Scroll up or down in small increments.
|
Up Arrow or
Down Arrow
|
Scroll up or down one full screen.
|
Page Up or Page Down
|
Move to the top or bottom of the page.
|
Ctrl+Up Arrow or
Ctrl+Down Arrow
|
Scroll to the left or right in small increments.
|
Left Arrow or
Right Arrow
|
Move to the left or right edge of the page.
|
Home or End
|
Move to the upper-left or upper-right corner of the page.
|
Ctrl+Home or Ctrl+End
|
Cancel Print Preview.
|
C or Esc
|
Navigate in the Query Designer
Action
|
Keyboard shortcut
|
Move among the Query Designer panes.
|
F6 or Shift+F6
|
Navigate in the top pane
TIP If multiple items are selected, pressing the Spacebar affects all selected items. Select multiple items by holding down the Shift key while clicking them. Toggle the selected state of a single item by holding down the Ctrl key while clicking it.
Action
|
Keyboard shortcut
|
Move among tables, views, and functions, (and to join lines, if available).
|
Tab or Shift+Tab
|
Move between columns in a table, view, or function.
|
Arrow keys
|
Choose the selected data column for output.
|
Spacebar or Plus key
|
Remove the selected data column from the query output.
|
Spacebar or Minus key
|
Remove the selected table, view, or function, or join line from the query.
|
Delete
|
Navigate in the query design grid
| |
Action
|
Keyboard shortcut
|
Move among cells.
|
Arrow keys or Tab or
Shift+Tab
|
Move to the last row in the current column.
|
Ctrl+Down Arrow
|
Move to the first row in the current column.
|
Ctrl+Up Arrow
|
Move to the upper-left cell in the visible portion of the grid.
|
Ctrl+Home
|
Move to the lower-right cell.
|
Ctrl+End
|
Move in a drop-down list.
|
Up Arrow or
Down Arrow
|
Select an entire grid column.
|
Ctrl+Spacebar
|
Toggle between edit mode and cell selection mode.
|
F2
|
Toggle between insert and overstrike mode while editing in a cell.
|
Ins
|
Toggle the check box in the Show column. (If multiple items are selected, pressing this key affects all selected items.)
|
Spacebar
|
Clear the selected contents of a cell.
|
Delete
|
Navigate in the SQL pane
You can use the standard Windows editing keys when working in the SQL pane, such as Ctrl+Arrow keys to move between words, and the Cut, Copy, and Paste commands on the Home tab.
TIP You can only insert text; there is no overstrike mode.
No comments:
Post a Comment