Database Shortcut Keys

From LibreOffice Help
Jump to: navigation, search

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

The general shortcut keys in LibreOffice also apply.

Note.png 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

Shortcut Keys Results
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 Preview
F5 Run query
F7 Add table or query

Control Properties Window

Shortcut Keys Results
Alt+Down Arrow Opens the combo box.
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.
Ctrl+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

Shortcut Keys Results
Ctrl+PgUp Jumps between tabs.
Ctrl+PgDn Jumps between tabs.
F6 Jump between windows.
Tab Selection of the control fields.
Shift+Tab Selection of the control fields in opposite direction.
Ctrl+Enter Inserts the selected control.
Arrow key

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.
Ctrl+Tab In point edit mode, jumps to next handle.
Shift+Ctrl+Tab In point edit mode, jumps to previous handle.
Esc Leaves the current selection.

Related Topics

== Selecting Rows and Columns in a Database Table (opened by F4) ==

{