OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 398)

Chapter 7: Databases and Data Sources

Versions of OpenOffice.org Base prior to 2.x required a connection to an external data

source. While 2.x retains this functionality, it also introduces the ability to create an

HSQLDB database as an internal data source. Now all the data tables, forms, queries and

reports for a database can reside in one .ODB file.

This chapter introduces built-in HSQLDB databases and touches on some of the functionality

still retained from earlier versions of Base. The examples found in this chapter are some of

the steps used to create the Calendar example database.

The large amount of preparatory work done when one is actually designing a database is

beyond the scope of this chapter. Briefly, the preparatory work for creating the Calendar

database involved sketching out what the user wanted to see as the end result and working

from there to design tables that would follow good database design theory or, failing that, at

least be easy to implement and maintain.

Creating a database file

After the preparatory work, a file or container must be created to hold all the parts of the

database.

If OpenOffice.org is already open, you can choose File > New > Database. You can

also open OpenOffice.org Base itself selecting the program icon from the menu or by

running sbase from the commandline.

The Database Wizard opens to Step 1, Select database.

1. Make sure the option is set to Create New Database and click Next.

2. In Step 2, Save and proceed, you will want the option regarding registering the

database (Do you want the wizard to register the database is OpenOffice.org?) set

to Yes, register the database for me.

When you register a database, OpenOffice.org now knows where the data is

located and how it is organized. In spreadsheets and text documents, you can use

View > Data Source to connect to the data.

3. Under After the database file has been saved, what do you want to do? Make sure

Open the database for editing is checked.

The Create tables using the table wizard check box opens the Table Wizard.

The Table Wizard offers a set of sample tables from which fields, with

corresponding types and formats, can be chosen to create a new table. Fields can

be chosen from multiple tables to create the particular table.

4. Click Finish.

5. In the Save As window that opens, name the database and select a location in which

to store it. Leave the Save as type set to OpenDocument Database.

OpenOffice.org User Guide for 2.x 364

1 2 ... 393 394 395 396 397 398 399 400 401 402 403 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 398