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

100

101

Figure 178: 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.

3) All other fields (Date, FuelCost, FuelQuantity, Odometer, and PaymentType):

• Type the next field name in the Field Name column.

• Select the Field Type for each field.

– For Date use Date[DATE]. (Press the D key to select it.)

– PaymentType uses Text [VARCHAR], the default setting.

– All other fields use Number [NUMERIC]. (Press the N key once to

select it.)

• FuelCost, FuelQuantity, and Odometer need changes in the Field

Properties section (Figure 179).

– FuelQuantity: Change Length to 6 and Decimal places to 3. (Many

fuel pumps measure fuel to thousands of a gallon in the USA where I

live.)

– Odometer: Change the Length to 10 and the Decimal places to 1.

– FuelCost: Change the Length to 5 and Decimal places to 2. Click the

Format example button. This opens the Field Format window

(Figure 180). Use Currency as the Category and your currency as the

Format. My currency has two decimal places. Use what is appropriate

for yours.

210 Getting Started with OpenOffice.org 3.3

1 2 ... 205 206 207 208 209 210 211 212 213 214 215 ... 378 379

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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