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

  Modified On Nov-29-2017 11:36:02 PM

Leave Comment