Navigating in the Query Designer
Any Pane
- F6, SHIFT+F6
- Move among the Query Designer panes
Diagram Pane
- TAB, or SHIFT+TAB
- Move among tables, views, and functions, (and to join lines, if available)
- Arrow keys
- Move between columns in a table, view, or function
- SPACEBAR or PLUS key
- Choose the selected data column for output
- SPACEBAR or MINUS key
- Remove the selected data column from the query output
- DELETE
- Remove the selected table, view, or functiion, or join line from the query
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.Grid Pane
- Arrow keys or TAB or SHIFT+TAB
- Move among cells
- CTRL+DOWN ARROW
- Move to the last row in the current column
- CTRL+UP ARROW
- Move to the first row in the current column
- CTRL+HOME
- Move to the top left cell in the visible portion of grid
- CTRL+END
- Move to the bottom right cell
- UP ARROW or DOWN ARROW
- Move in a drop-down list
- CTRL+SPACEBAR
- Select an entire grid column
- F2
- Toggle between edit mode and cell selection mode
- CTRL+C
- Copy selected text in cell to the Clipboard (in edit mode)
- CTRL+X
- Cut selected text in cell and place it on the Clipboard (in edit mode)
- CTRL+V
- Paste text from the Clipboard (in edit mode)
- INS
- Toggle between insert and overstrike mode while editing in a cell
- SPACEBAR
- Toggle the check box in the Output column
- Note If multiple items are selected, pressing this key affects all selected items.
- DELETE
- Clear the selected contents of a cell
- DELETE
- Remove row containing selected data column from the query
- Note If multiple items are selected, pressing this key affects all selected items.
- DELETE
- Clear all values for a selected grid column
- INS ( after you select grid row)
- Insert row between existing rows
- INS ( after you select any Or ... column)
- Add an Or à column
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.