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

100

101

The first table to be created is Fuel. Its fields are FuelID, Date,

FuelCost, FuelQuantity, Odometer, and PaymentType.

1) Click Create Table in Design View.

2) FuelID field:

a) Type FuelID as the first Field Name. Press the Tab key to

move to the Field Type column.

b) Select Integer [INTEGER] as the Field Type from the

dropdown list. (The default setting is Text [VARCHAR].)

Tip

A shortcut for selecting from the Field Type dropdown list: press

the key for the first letter of the choice. You can cycle through

the choices for a given letter by repeatedly pressing that key.

c) Change the Field Properties in the bottom section.

Change AutoValue from No to Yes.

d) Set FuelID as the Primary key.

Right-click on the green triangle to the left of FuelID

(Figure 186) and choose Primary Key from the menu. This

places a key icon in front of FuelID.

Figure 186: Defining the primary key field

Note

The primary key serves only one purpose: to uniquely identify

the record. Any name can be used for this field. We have used

FuelID for convenience, so we know to which table it belongs.

260 Getting Started with OpenOffice.org 3.x

Free eBook Edition

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

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 260

Comentarios a estos manuales

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 260

Comentarios a estos manuales

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