Navigate in the Query and View Designer (Visual Database Tools)

  • Article

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

Design Queries and Views How-to Topics (Visual Database Tools)