Contents
Index 🔎︎

# Database Shortcut Keys

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

The general shortcut keys in LibreOffice also apply.

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 - Customise - Keyboard, or in your desktop system.

## Shortcut keys for databases

### In the query design

Shortcut Keys | Effect
F6 | Jump between the query design areas.
Delete | Deletes a table from the query design.
Tab | Selects the connection line.
Shift+F10 | Opens the context menu.
F4 | Shows a Preview.
F5 | Runs query.
F7 | Adds table or query.

### Control Properties Window

Shortcut Keys | Effect
Option Alt+Down Arrow | Opens the combo box.
Option Alt+Up Arrow | Closes the combo box.
Shift+Enter | Inserts a new line.
Up arrow | Positions the cursor in the previous line.
Down arrow | Puts the cursor into the next line.
Enter | Completes the input in the field and places the cursor into the next field.
Command Ctrl+F6 | Moves 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

Shortcut Keys | Effect
Command Ctrl+PgUp | Jumps between tabs.
Command Ctrl+PgDn | Jumps between tabs.
F6 | Jumps between windows.
Tab | Selection of the control fields.
Shift+Tab | Selection of the control fields in opposite direction.
Command Ctrl+Enter | Inserts the selected control.
Arrow key Command Ctrl+arrow key | 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.
Command Ctrl+Tab | In point edit mode, jumps to next handle.
Shift+Command Ctrl+Tab | In point edit mode, jumps to previous handle.
Esc | Leaves the current selection.

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

Shortcut keys | Effect
Spacebar | Toggles row selection, except when the row is in edit mode.
Command Ctrl+Spacebar | Toggles row selection.
Shift+Spacebar | Selects the current column.
Command Ctrl+Page Up | Moves pointer to the first row.
Command Ctrl+Page Down | Moves pointer to the last row.

Related Topics

General Shortcut Keys in LibreOffice

Shortcuts (LibreOffice Accessibility)