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

Navigate 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.

ToPressClick
Move among the Query and View Designer panesF6, SHIFT+F6Anywhere in the target pane
System_CAPS_ICON_tip.jpg Tip


You can use the shortcut keys CTRL+TAB to change focus to other panes in addition to the Query and View Designer panes.

ToPressClick
Move among tables, other table-structured objects, (and to join lines, if available)TAB, or SHIFT+TABThe table, table-structured object, or join line to move to
Move between columns in a table or table-structured objectArrow keysThe column to go to
Choose the selected data column for outputSPACEBAR or PLUS keyThe check box next to the name of the column
Remove the selected data column from the query outputSPACEBAR or MINUS keyThe check box next to the name of the column
Remove the selected table, table-structured object, or join line from the queryDELETERight-click, and then choose Remove
System_CAPS_ICON_note.jpg 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).

ToPressClick
Move among cellsArrow keys or TAB or SHIFT+TABThe target cell
Move to the last row in a selected columnCTRL+DOWN ARROW
Move to the first row in a selected columnCTRL+UP ARROW
Move to the top left cell in the visible portion of gridCTRL+HOME
Move to the bottom right cellCTRL+END
Move in a drop-down listUP ARROW or DOWN ARROWThe button in the cell
Select an entire grid columnCTRL+SPACEBARThe column header
Toggle between edit mode and cell selection modeF2
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 cellINS
Toggle the check box in the Output columnSPACEBARThe check box
Clear the selected contents of a cellDELETE
Clear all values for a selected grid columnDELETE
Insert row between existing rowsINS after you select grid row
Add an Or ... columnINS after you select any Or ... column
System_CAPS_ICON_note.jpg Note


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

For more information, see Criteria Pane (Visual Database Tools).

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.

System_CAPS_ICON_note.jpg Note


You can only insert text; there is no overstrike mode.

For more information, see SQL Pane (Visual Database Tools).

ToPressClick
Move between cellsArrow keys or TAB or SHIFT+TABThe target cell
Move to first or last cell in current rowHOME or END
Move to the first row in the current columnCTRL+UP ARROW
Move to the top left cellCTRL+HOME
Move to the bottom cell in the first columnCTRL+DOWN ARROW
Select to first character in a cellSHIFT+HOME
Select to last character in a cellSHIFT+END
Toggle between edit mode and cell selection modeF2
Toggle between insert and overstrike mode while editing in a cellINS
Delete a row from the tableDELETE
Undo changes for the current cellESC in cell that has changed
Undo changes for the current rowESC in any cell that has not changed
Enter null into a cellCTRL+0
Copy selected columns or rows to the ClipboardCTRL+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
System_CAPS_ICON_note.jpg Note


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

For more information, see Results Pane (Visual Database Tools).

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

Community Additions

ADD
Show:
© 2016 Microsoft