Getting Started Guide

Using data sources in OpenOffice.org
Having registered the data source, whether a spreadsheet, text document, external
database or other accepted data source, you can use it in other OpenOffice.org
components including Writer and Calc.
Viewing data sources
Open a document in Writer or Calc. To view the data sources available, press F4 or
select View > Data Sources from the pull-down menu. This brings up a list of
registered databases, which will include Bibliography and any other database
registered, such as the Automobile database created earlier in this chapter.
To view each database, click on the + to the left of the database’s name (see Figure
210). This brings up Tables and Queries. Click on the + next to Tables to view the
individual tables created. Now click on a table to see all the records held in it.
Figure 210: Databases
Editing data sources
Some data sources can be edited in the View Data Sources dialog. A spreadsheet can
not. A record can be edited, added, or deleted.
The data is displayed on the right side of the screen. Click in a field to edit the value.
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 211: 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 212: Deleting a row in the Data View window
Chapter 8 Getting Started with Base 231
Insert new record