In this article I am trying to explain the shortcut keys for navigate in the query designer for MS Access
Any Pane
Key | Description |
F6, SHIFT+F6 | Move among the Query Designer panes |
Diagram Pane
Key | Description |
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 function, or join line from the query |
Grid Pane
Key | Description |
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 |
DELETE | Clear the selected contents of a cell |
DELETE | Remove row containing selected data column from the query |
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 |
Leave Comment