This section contains information on browsing and editing database tables.
|You cannot use the data source browser on a database table that is open in Design view.|
- 1 Data source browser
- 2 Table Data Bar
- 3 Delete Rows
- 4 Hide Columns
- 5 Show Columns
Data source browser
To select a record in a database table, click the row header, or click a row header, and then use the Up or Down arrow keys.
The following table describes how to select individual elements in the data source browser:
|Record||Click the row header|
|Several records or removing a selection||Hold down Ctrl and click the row header|
|Column||Click the column header|
|Data field||Click in the data field|
|Entire table||Click the row header of the column headings|
Table Data toolbar (editing table data)
|Allows you to edit, add, or delete records from the database table.|
Cutting, copying and pasting data
You can cut, copy, and paste records in Data Source view. The Data Source browser also supports the dragging and dropping of records, or text and numbers from other LibreOffice files.
You cannot drag and drop to Yes/No, binary, image, or counting table fields.
|Drag and drop only works in Edit mode.|
Use the Table Data bar to control the data view.
Use the Form Navigation bar at the bottom of the Data Source view to navigate between different records.
Go to the first record in the table.
Go to the previous record in the table.
Type the number of the record that you want to display, and then press Enter.
Go to the next record in the table.
Go to the last record in the table.
Inserts a new record into the current table. To create a record, click the asterisk (*) button at the bottom of the table view. An empty row is added at the end of the table.
Number of records
Displays the number of records. For example, "Record 7 of 9(2)" indicates that two records (2) are selected in a table containing 9 records, and that the cursor is in record number 7.
To access the commands for formatting the table, right-click a column header, or a row header.
Formats the selected row(s).
Changes the height of the current row, or the selected rows.
Deletes the selected row(s).
Formats the selected column(s).
Changes the width of the current column, or the selected columns.
Hides the selected column(s). To display hidden columns, right-click any column header, and then choose Show Columns.
Displays hidden columns. Choose the column that you want to display from the list, or click All to display all of the hidden columns.