Database Shortcut Keys

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

The general shortcut keys in LibreOffice also apply.

Note Icon

Iuj fulmoklavoj eble estas atribuitaj al via labortablo. Klavoj atribuitaj al la labortablo ne disponeblas al LibreOffice. Provu atribui diferencajn klavojn aÅ­ por LibreOffice, en Iloj - Adapti - Klavaro, aÅ­ en via labortabla sistemo.


Shortcut keys for databases

In the query design

Fulmklavoj

Efekto

F6

Jump between the query design areas.

Forigi

Deletes a table from the query design.

Tabo

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

Fulmklavoj

Efekto

+Y

Opens the combo box.

+Y

Closes the combo box.

Shift+Enter

Inserts a new line.

Suprensago

Positions the cursor in the previous line.

Sago Malsupren

Puts the cursor into the next line.

Enter

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

+Y

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

Fulmklavoj

Efekto

+Y

Jumps between tabs.

+Y

Jumps between tabs.

F6

Jumps between windows.

Tabo

Selection of the control fields.

Majuskligo+Tabo

Selection of the control fields in opposite direction.

+Y

Inserts the selected control.

Sagoklavo

+Y

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.

+Tabo

In point edit mode, jumps to next handle.

+Y

In point edit mode, jumps to previous handle.

ESK

Leaves the current selection.


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

Fulmklavoj

Efekto

Spacostango

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

+Y

Toggles row selection.

Shift+Spacebar

Selects the current column.

+Y

Moves pointer to the first row.

+Y

Moves pointer to the last row.