Getting Started Guide

Registering *.odb databases
Databases created by OOo2.x or later are in the *.odb (OpenDocument
Base) format. Other programs can also produce databases in this
format. Registered a *.odb database is simple:
1) Choose Tools > Options > OpenOffice.org Base > Databases.
2) Under Registered databases, click New.
3) Browse to where the database is located.
4) Make sure the registered name is correct.
5) Click OK.
Note
Sometimes when updating OOo to a newer version, your list of
registered database files disappears. When that happens, you
need to use these steps to register your database files with your
latest version of OOo.
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 218). 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 218: Databases
Chapter 8 Getting Started with Base 285
Free eBook Edition