Table Data Bar
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
|
|
Save Record |
Edit Data
Turns the edit mode for the current database table on or off.
|
|
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.
|
|
Undo: Data Input |
Find Record
In forms or database tables, you can search through data fields, list boxes, and check boxes for specific values.
|
|
Find Record |
Refresh
Refreshes the displayed data. In a multi-user environment, refreshing the data ensures that it remains current.
|
|
Refresh |
Sort Order
Specifies the sort criteria for the data display.
|
|
Sort Order |
Sort Ascending
Text fields are sorted alphabetically (A-Z), numerical fields in ascending order (0-9).
|
|
Sort Ascending |
Sort Descending
Text fields are sorted alphabetically (Z-A), number fields in numerically descending order (9-0).
|
|
Sort Descending |
AutoFilter
Filters the records based on the content of the currently selected data field.
|
|
AutoFilter |
Apply Filter
Switches between the filtered and unfiltered view of the table.
|
|
Apply Filter |
Standard Filter
Allows you to set the filtering options.
|
|
Standard Filter |
Remove Filter/Sorting
Cancels the filter settings and displays all of the records in the current table.
|
|
Remove Filter/Sorting |
Inserts all fields of the marked record into the current document at the cursor position.
|
|
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.
|
|
Data to Fields |
Starts the Mail Merge Wizard to create form letters.
|
|
Mail Merge |
Data Source of Current Document
Displays, in the data source browser, the table that is linked to the current document.
|
|
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.
|
|
Explorer On/Off |
Index
records, saving
read-only documents, database tables on/off
protected database tables
data, read-only
undoing,editing
editing,undoing
default filters, databases
databases, standard filters
standard filters in databases
data sources, displaying current
This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.
