Introduction
A data source, or database, is a collection of pieces of information that
can be accessed or managed by OpenOffice.org (OOo). For example, a
list of names and addresses is a data source that could be used for
producing a mail merge letter. A shop stock list could be a data source
managed through OOo.
Note
OpenOffice.org uses the terms “Data Source” and “Database” to
refer to the same thing, which could be a database such as
MySQL or dBase or a spreadsheet or text document holding data.
This chapter covers creating a database, showing what is contained in
a database and how the different parts are used by OOo. It also covers
using the Base component of OOo to register other data sources. A
data source can be a database, spreadsheet, or text document.
Note
OOo Base uses the HSQL database engine. All of the files
created by this engine are kept in one zipped file. The database
forms are included in this zipped file.
A database consists of a number of fields that contain the individual
pieces of data. Each table of the database is a group of fields. When
creating a table, you also determine the characteristics of each field in
the table. Forms are for data entry into the fields of one or more tables
associated with the form. They can also be used for viewing fields from
one or more tables associated with the form. A query creates a new
table from the existing tables based upon how you create the query. A
report organizes the information of the fields of a query in a document
according to your requirements.
Caution
The database in OOo requires Java Runtime Environment (JRE).
If you do not have it on your computer, you can download it
from www.java.com and install it following the instructions on
the site. It should be Java 5.0 or higher. In OOo, use Tools >
Options > OpenOffice.org > Java to register Java.
Windows' version of JRE can not be used, while there are other
versions that can.
Base creates relational databases. This makes it fairly easy to create a
database in which the fields of the database have relationships with
each other.
For example: Consider a database for a library. It will contain a field
for the names of the authors and another field for the names of the
Chapter 8 Getting Started with Base 251
(464 paginas)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales