Access 2003 Shortcut Keys
[Keys for General Use] [Keys
for Use in the Database Window] [Keys
for Navigating Records] [Keys for Selecting
Text or Data] [Keys for Editing Text or Data] [Keys for Working in Print Preview and Layout Preview]
[Keys for Working in the Query Designer in an Access
Project] [Keys for Working with PivotTable and
PivotChart Views]
Keys for Working in the Query Designer in an Access Project
All shortcut keys are based on the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard.
For keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign,
like this: SHIFT+F10.
For shortcuts in which you press keys one after the other, the keys to press are separated by a comma,
like this: ALT, F, X.
Navigating Panes
To perform this
action... |
Press... |
To move among the
Query Designer panes |
F6, SHIFT+F6
|
Navigating the Diagram Pane
To perform this
action... |
Press... |
To move among
tables, views, and functions (and to join lines, if available)
|
TAB,
or SHIFT+TAB |
To move between
columns in a table, view, or function |
Arrow keys
|
To choose the
selected data column for output |
SPACEBAR
or PLUS key |
To remove the
selected data column from the query output |
SPACEBAR
or MINUS key |
To remove the
selected table, view, or function, or join line from the query
|
DELETE
|
Note:
If multiple items are selected, pressing 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 CTRL while clicking it.
Navigating the Grid Pane
To perform this
action... |
Press... |
To move among cells
|
Arrow keys
or TAB or SHIFT+TAB
|
To move to the last
row in the current column |
CTRL+DOWN ARROW
|
To move to the first
row in the current column |
CTRL+UP ARROW
|
To move to the top
left cell in the visible portion of grid |
CTRL+HOME
|
To move to the
bottom right cell |
CTRL+END
|
To move in a
drop-down list |
UP ARROW
or DOWN ARROW |
To select an entire
grid column |
CTRL+SPACEBAR
|
To toggle between
edit mode and cell selection mode |
F2
|
To copy selected
text in cell to the Clipboard (in edit mode) |
CTRL+C
|
To cut selected text
in cell and place it on the Clipboard (in edit mode) |
CTRL+X
|
To paste text from
the Clipboard (in edit mode) |
CTRL+V
|
To toggle between
insert and overstrike mode while editing in a cell |
INS
|
To toggle the check
box in the Output column |
SPACEBAR
(If
multiple items are selected, pressing this key affects all selected
items) |
To clear the
selected contents of a cell |
DELETE |
To remove row
containing selected data column from the query |
DELETE
(If multiple items are selected, pressing this key affects all selected
items) |
To clear all values
for a selected grid column |
DELETE |
To insert row
between existing rows |
INS
(after you select grid row) |
To add an Or �
column |
INS
(after you select any Or ... column) |
Navigating 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 Edit menu.
Note: You can only insert text; there is no overstrike mode.
Navigating Page View
To use the following keys, press the TAB key repeatedly until the expand
indicator or record navigation toolbar has
the focus. If a PivotTable list or
spreadsheet control currently has the focus,
press ESC.
To perform this
action... |
Press... |
To expand or
collapse a group of records corresponding to the expand indicator in a
grouped data access page.
|
SPACE
or ENTER |
To select a button
on the record navigation toolbar |
TAB
or SHIFT+TAB |
To activate the
selected button on the record navigation toolbar |
SPACE
or ENTER |
Go Back to the Top of the Page |