Getting Started Guide

1) File > New > Database opens the Database Wizard window.
2) Select Connect to an existing database. Click the arrow next to the
Database type field and select the database type from the dropdown list. Click
Next.
3) Click Browse and select the database. Click Next.
4) Accept the default settings: Register the database for me, and Open the
database for editing. Click Finish. Name and save the database in the location
of your choice.
Accessing a spreadsheet as a data source
Accessing a spreadsheet is similar to accessing other databases:
1) Choose File > New > Database.
2) Select Connect to an existing database. Select Spreadsheet as the Database
type.
3) Click Browse to locate the spreadsheet you want to access. If the spreadsheet
is password protected, check the Password required box. Click Next.
4) If the spreadsheet requires a user’s name, enter it. If a password is also
required, check its box. Click Next.
Note
Using this method of accessing a spreadsheet, you cannot change
anything in the spreadsheet. You can only view the contents of the
spreadsheet, run queries, and create reports based upon the data
already entered into the spreadsheet.
All changes in a spreadsheet must be made in the spreadsheet itself,
using Calc. After modifying the spreadsheet and saving it, you will see
the changes in the database. If you create and save an additional sheet
in your spreadsheet, the database will have a new table the next time
you access it.
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.
230 Getting Started with OpenOffice.org 3.3