Navigating in the Query and View Designer (Visual Database Tools)
You can work in the Query and View Designer using the keyboard or the mouse. Refer to the following tables for specific methods.
Any Pane
| To | Press | Click |
|---|---|---|
Move among the Query and View Designer panes |
F6, SHIFT+F6 |
Anywhere in the target pane |
Tip
You can use the shortcut keys CTRL+TAB to change focus to other panes in addition to the Query and View Designer panes.
Diagram Pane
| To | Press | Click |
|---|---|---|
Move among tables, other table-structured objects, (and to join lines, if available) |
TAB, or SHIFT+TAB |
The table, table-structured object, or join line to move to |
Move between columns in a table or table-structured object |
Arrow keys |
The column to go to |
Choose the selected data column for output |
SPACEBAR or PLUS key |
The check box next to the name of the column |
Remove the selected data column from the query output |
SPACEBAR or MINUS key |
The check box next to the name of the column |
Remove the selected table, table-structured object, or join line from the query |
DELETE |
Right-click, and then choose Remove |
Note
If multiple items are selected, pressing this key affects all selected items. Select multiple items by holding down the CTRL key while clicking them.
For more information, see Diagram Pane (Visual Database Tools).
Criteria Pane
| To | Press | Click |
|---|---|---|
Move among cells |
Arrow keys or TAB or SHIFT+TAB |
The target cell |
Move to the last row in a selected column |
CTRL+DOWN ARROW |
|
Move to the first row in a selected column |
CTRL+UP ARROW |
|
Move to the top left cell in the visible portion of grid |
CTRL+HOME |
|
Move to the bottom right cell |
CTRL+END |
|
Move in a drop-down list |
UP ARROW or DOWN ARROW |
The button in the cell |
Select an entire grid column |
CTRL+SPACEBAR |
The column header |
Toggle between edit mode and cell selection mode |
F2 |
|
Copy selected text in cell to the Clipboard (in edit mode) |
CTRL+C |
|
Cut selected text in cell and place it on the Clipboard (in edit mode) |
CTRL+X |
|
Paste text from the Clipboard (in edit mode) |
CTRL+V |
|
Toggle between insert and overstrike mode while editing in a cell |
INS |
|
Toggle the check box in the Output column |
SPACEBAR |
The check box |
Clear the selected contents of a cell |
DELETE |
|
Clear all values for a selected grid column |
DELETE |
|
Insert row between existing rows |
INS after you select grid row |
|
Add an Or ... column |
INS after you select any Or ... column |
|
Note
If multiple items are selected, pressing this key affects all selected items.
For more information, see Criteria Pane (Visual Database Tools).
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.
For more information, see SQL Pane (Visual Database Tools).
Results Pane
| To | Press | Click |
|---|---|---|
Move between cells |
Arrow keys or TAB or SHIFT+TAB |
The target cell |
Move to first or last cell in current row |
HOME or END |
|
Move to the first row in the current column |
CTRL+UP ARROW |
|
Move to the top left cell |
CTRL+HOME |
|
Move to the bottom cell in the first column |
CTRL+DOWN ARROW |
|
Select to first character in a cell |
SHIFT+HOME |
|
Select to last character in a cell |
SHIFT+END |
|
Toggle between edit mode and cell selection mode |
F2 |
|
Toggle between insert and overstrike mode while editing in a cell |
INS |
|
Delete a row from the table |
DELETE |
|
Undo changes for the current cell |
ESC in cell that has changed |
|
Undo changes for the current row |
ESC in any cell that has not changed |
|
Enter null into a cell |
CTRL+0 |
|
Copy selected columns or rows to the Clipboard |
CTRL+C |
|
Copy selected text in cell to the Clipboard (in edit mode) |
CTRL+C |
|
Cut selected text in cell to the Clipboard (in edit mode) |
CTRL+X |
|
Paste text from the Clipboard (in edit mode) |
CTRL+V |
|
Note
If multiple items are selected, pressing this key affects all selected items.
For more information, see Results Pane (Visual Database Tools).
See Also
Other Resources
Designing Queries and Views (Visual Database Tools)