Operation Manual

Figure 226: Databases
Editing data sources
Some data sources (but not spreadsheets) can be edited in the Data View window. A record can be
edited, added, or deleted.
View a table’s data
If you click on a table its rows and columns of data appear on the right side of the Data Source
window. Editing this data requires only a click in the cell whose data should be changed, change
the data, and click in the row above or below it to save the new data.
Beneath the records are five tiny buttons. The first four move backwards or forwards through the
records, or to the beginning or end. The fifth button, with a small star, inserts a new record.
Figure 227: View Data Sources navigation buttons
To delete a record, right-click on the gray box to the left of a row to highlight the entire row, and
select Delete Rows to remove the selected row.
Figure 228: Deleting a row in the Data View window
Launching Base to work on data sources
You can launch LibreOffice Base at any time from the Data Source window. Just right-click on a
database or its Tables or Queries icons and select Edit Database File. Once in Base, you can edit,
add, and delete tables, queries, forms, and reports.
Using data sources in Writer and Calc
Data can be placed into Writer and Calc documents from the tables in the data source window. In
Writer, values from individual fields can be inserted. Or a complete table can be created in the
Writer document. One common way to use a data source is to perform a mail merge.
Figure 229: Toolbar for the Data Sources window
240 | Getting Started with LibreOffice 4.0