Home Up Bookstore Site Map Site Search

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


Home ] 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 ]

Send mail with questions or comments about this web site to our webmaster.
Last modified: June 05, 2004

Labelled with ICRA