OpenOffice.org OpenOffice - 3.2 Przewodnik Szybki Start Pobierz pdf (Strona 259)

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 needed. (See Caution below for the reason

why.) Click Create. The new table is created.

Caution

Once tables have been created using the wizard and data has

been entered, editing them should be very limited. Fields can

be added or deleted, but adding a field requires taking the time

to enter the data for that one field for every record having an

entry for that field.

Deleting a field deletes all the data once contained in that

field. Changing the field type of a field can lead to data being

lost either partially or completely. When creating a new table, it

pays to create the fields with the correct names, length, and

format before you add any data.

Deleting a table removes all of the data contained in every field

of the table. Unless you are sure, do not delete a table.

Creating tables in Design View

Design View is a more advanced method for creating a new table, in

which you directly enter information about each field in the table. We

will use this method for the tables of our database.

Note

While the Field type and formatting are different in Design View,

the concepts are the same as in the Wizard.

Chapter 8 Getting Started with Base 259

Free eBook Edition

1 2 ... 254 255 256 257 258 259 260 261 262 263 264 ... 441 442

Brak uwag

OpenOffice.org OpenOffice - 3.2 Przewodnik Szybki Start Strona 259