Navigating in the Query Designer

You can work in the Query Designer using the keyboard or the mouse. Refer to the following tables for specific methods.

Any Pane

To Press Click
Move among the Query Designer panes F6, SHIFT+F6 Anywhere in the target pane

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 SPACEBAR1 or
PLUS key
The check box next to the name of the column
Remove the selected data column from the query output SPACEBAR1 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

1    If multiple items are selected, pressing this key 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.

Grid Pane

To Press Click
Move among cells Arrow keys or TAB or SHIFT+TAB The target cell
Move to the last row in the current column CTRL+DOWN ARROW  
Move to the first row in the current 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
Select an entire grid row   The button to the left of the row
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 SPACEBAR1 The check box
Clear the selected contents of a cell DELETE  
Remove row containing selected data column from the query DELETE1  
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  

1    If multiple items are selected, pressing this key affects all selected items.

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.

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  
Select an entire grid column CTRL+SPACEBAR The column header
Select an entire grid row   The button to the left of the row
Toggle between edit mode and cell selection mode F2  
Toggle between insert and overstrike mode while editing in a cell INS  
Insert a new row into the grid (moves to last row in grid) INS while cell is selected  
Delete a row from the table DELETE1  
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  

1    If multiple items are selected, pressing this key affects all selected items.

See Also

Reference

Show: