Table Data Bar

From LibreOffice Help
Jump to: navigation, search

Use the Table Data bar to control the data view.

The filtered data view is active until you change or cancel the sorting or filtering criteria. If a filter is active, the Apply Filter icon on the Table Data bar is activated.

Save Record

Saves the current database table record. The Save Record icon is found on the Table Data bar

Icon
Save Record

Edit Data

Turns the edit mode for the current database table on or off.

Icon
Edit Data

Undo

Reverses the last command or the last entry you typed. To select the command that you want to reverse, click the arrow next to the Undo icon on the Standard bar.

Icon
Undo: Data Input

Find Record

In forms or database tables, you can search through data fields, list boxes, and check boxes for specific values.

Icon
Find Record

Refresh

Refreshes the displayed data. In a multi-user environment, refreshing the data ensures that it remains current.

Icon
Refresh

Sort Order

Specifies the sort criteria for the data display.

Icon
Sort Order

Sort Ascending

Text fields are sorted alphabetically, numerical fields are sorted by number.

Icon
Sort Ascending

Sort Descending

Text fields are sorted alphabetically, number fields are sorted by number.

Icon
Sort Descending

AutoFilter

Filters the records, based on the content of the currently selected data field.

Icon
AutoFilter

Apply Filter

Switches between the filtered and unfiltered view of the table.

Icon
Apply Filter

Standard Filter

Allows you to set the filtering options.

Icon
Standard Filter

Reset Filter/Sorting

Cancels the filter settings and displays all of the records in the current table.

Icon
Reset Filter/Sorting

Data to Text

Inserts all fields of the marked record into the current document at the cursor position.

Icon
Data to Text

Data to Fields

Updates the contents of the existing database fields by the marked records. The Data to Fields icon is only available if the current document is a text document.

Icon
Data to Fields

Mail Merge

Starts the Mail Merge Wizard to create form letters.

Icon
Mail Merge

Data Source of Current Document

Displays, in the data source browser, the table that is linked to the current document.

Icon
Data Source of Current Document

Explorer On/Off

Turns on and off the view of the data source explorer. The Explorer On/Off icon is visible on the Table Data bar.

Icon
Explorer On/Off