Operation Manual

Note
The primary key serves only one purpose: to identify each record uniquely. 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):
a) Type the next field name in the Field Name column.
b) Select the Field Type for each field.
• For Date use Date[DATE]. (Press the D key to select it.)
• All other fields use Number [NUMERIC]. (Press the N key once to select it.)
• PaymentType uses Text [VARCHAR], the default setting.
c) FuelCost, FuelQuantity, and Odometer need changes in the Field Properties section
(Figure 209).
• FuelCost: Change the Length to 5 and Decimal places to 2. Click the Format
example ellipse button (...) (Figure 209). This opens the Field Format window
(Figure 210). Use Currency as the Category and your currency as the Format.
My currency has two decimal places. Use what is appropriate for yours.
• FuelQuantity: Change Length to 6 and Decimal places to 3. (Many fuel pumps
measure fuel to thousandths of a gallon in the USA, where I live.)Odometer:
Change the Length to 10 and the Decimal places to 1.
d) Repeat steps a) through c) until you have entered all of the fields.
Figure 209: Changing field properties
e) To access additional formatting options, click the ellipse button (…) to the right of the
Format example field.
Description can be any of the categories listed in the figure below, or can be left blank.
228 | Getting Started with LibreOffice 5.0