OpenOffice.org OpenOffice - 3.3 Guía de inicio rápido descargar pdf (Pagina 208)

Note

Each field has a Field Type, which must be specified. Types include text,

integer, date, and decimal. If the field is going to have general information

in it (for example, a name or a description), use text. If the field will always

contain a number (for example, a price), the type should be decimal or

another numerical field. The wizard picks the right field type, so to get an

idea of how this works, see what the wizard has chosen for different fields.

Step 3: Set primary key.

1) Create a primary key should be checked.

2) Select option Use an existing field as a primary key.

3) In the Fieldname dropdown list, select CollectionID.

4) Check Auto value if it is not already checked.

5) Click Next.

Note

A primary key uniquely identifies an item (or record) in the table. For

example, you might know two people called “Randy Herring” or three

people living at the same address and the database needs to distinguish

between them.

The simplest method is to assign a unique number to each one: number the

first person 1, the second 2, and so on. Each entry has one number and

every number is different, so it is easy to say “record ID 172”. This is the

option chosen here: CollectionID is just a number assigned automatically

by Base to each record of this table.

Step 4: Create the table.

1) If desired, rename the table at this point. If you rename it, make the name

meaningful to you. For this example, make no changes.

2) Leave the option Insert data immediately checked.

3) Click Finish to complete the table wizard. Close the window created by the

table wizard. You are now back to the main window of the database with the

listing of the tables, queries, forms, and reports. Notice that a table named

“CD-Collection” is now listed in the Tables portion of the window.

Creating a table by copying an existing table

If you have a large collection of music, you might want to create a table for each type

of music you have. Rather than creating each table from the wizard, you can make

copies of the original table, naming each according to the type of music contained in

it.

1) Click on the Tables icon in the Database pane to see the existing tables.

2) Right-click on the CD-Collection table icon. Choose Copy from the pop-up

menu.

3) Move the mouse pointer below this table, right-click, and select Paste. The

Copy table dialog opens.

4) Change the table name to Pop and click Next.

5) Click the >> button to move all the fields from the left box to the right box and

click Next.

6) Since all the fields already have the proper Field type, no changes should be

needed. However, this is the time and place to make any changes if they are

208 Getting Started with OpenOffice.org 3.3

1 2 ... 203 204 205 206 207 208 209 210 211 212 213 ... 378 379

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía de inicio rápido Pagina 208

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.3