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 |
