Database Shortcut Keys

The following is a list of shortcut keys available within databases.

The general shortcut keys in LibreOffice also apply.

Note Icon

Some of the shortcut keys may be assigned to your desktop system. Keys that are assigned to the desktop system are not available to LibreOffice. Try to assign different keys either for LibreOffice, in Tools - Customize - Keyboard, or in your desktop system.


Shortcut keys for databases

In the query design

āŠŸāŦāŠ‚āŠ•āŠūāŠĢ āŠ•āŠģ

Effect

F6

Jump between the query design areas.

āŠĶāŦ‚āŠ° āŠ•āŠ°āŦ‹

Deletes a table from the query design.

āŠŸāŦ‡āŠŽ

Selects the connection line.

Shift+F2

Opens a context menu.

F4

Shows a Preview.

F5

Runs query.

F7

Adds table or query.


Control Properties Window

āŠŸāŦāŠ‚āŠ•āŠūāŠĢ āŠ•āŠģ

Effect

+Up Arrow

Opens the combo box.

+Up Arrow

Closes the combo box.

Shift+Enter

Inserts a new line.

āŠ‰āŠŠāŠ°āŠĻāŦāŠ‚ āŠĪāŦ€āŠ°

Positions the cursor in the previous line.

āŠĻāŦ€āŠšāŦ‡āŠĻāŦāŠ‚ āŠĪāŦ€āŠ°

Puts the cursor into the next line.

Enter

Completes the input in the field and places the cursor into the next field.

+F6

Sets the focus (if not in design mode) to the first control. The first control is the first one listed in the Form Navigator.


Shortcuts for creating Basic dialogs

āŠŸāŦāŠ‚āŠ•āŠūāŠĢ āŠ•āŠģ

Effect

+PageUp

Jumps between tabs.

+D

Jumps between tabs.

F6

Jumps between windows.

āŠŸāŦ‡āŠŽ

Selection of the control fields.

Shift + Tab

Selection of the control fields in opposite direction.

+End

Inserts the selected control.

Arrow key

+Home

Moves the selected control in steps of 1 mm in the respective direction. In point edit mode, it changes the size of the selected control.

+ Tab

In point edit mode, jumps to next handle.

Shift++N

In point edit mode, jumps to previous handle.

Esc

Leaves the current selection.


Selecting Rows and Columns in a Database Table (opened by +Shift+F4 keys)

Shortcut keys

Effect

Spacebar

Toggles row selection, except when the row is in edit mode.

+ Tab

Toggles row selection.

Shift+Spacebar

Selects the current column.

+PageUp

Moves pointer to the first row.

+D

Moves pointer to the last row.


Please support us!