Writer Guide
Tip
Setting up the Primary Key field with Auto Value set to Yes is
an important step. If this is not done, the form you create later
will be much trickier to use and may generate errors for the
user. Make sure you get this step right!
4) On three lines, enter under Field Name
Name, Address
and
Telephone.
Accept the default Field Type of Text [VARCHAR] and
leave Description blank.
5) Save the table (File > Save). You will be prompted to name it (the
name can be anything you like).
6) Finally, save the whole database from the main Base window
(File > Save).
Figure 411: Database table design
Accessing an existing data source
If you have an existing data source, such as a spreadsheet or database,
you simply need to tell OpenOffice.org about it. This is called
registering a data source.
To register an existing data source:
1) Select File > New > Database to launch the Database Wizard
(Figure 412).
2) Select Connect to an existing database and choose the type
from the drop-down list.
482 OpenOffice.org 3 Writer Guide