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

Adding records to a spreadsheet is fairly easy. You need to have the

Data Source window open, your spreadsheet open, and the table you

want to use selected.

1) Click the gray box above the field name for the table's ID field.

2) Drop and drag the gray box for the table's ID field to where you

want the record to appear in the spreadsheet.

3) Repeat until you have moved all of the fields you need to where

you want them.

4) Name and save the spreadsheet.

5) Click a row of the table in the Data Source window.

6) Drag the data in the ID field in the selected row onto the ID field

in the spreadsheet. The Save icon should activate.

7) Click the Edit File button to make the spreadsheet read only.

Click Save when asked if you want to save the file.

8) The Data Source window goes blank, the fields in the spreadsheet

are populated with data from the row you selected, and the Form

Navigation toolbar appears at the bottom of the spreadsheet.

(Figure 223)

Figure 223: Navigation arrows of a form

9) Click the arrows on the Form Navigation toolbar to view the

different records of the table. (The arrows are circled in red.) The

number in the box changes when you change the record number

by clicking an arrow. The data in the fields changes

correspondingly to the data for that particular record number.

Entering data in a form

Records are used to organize the data we enter into a form. They also

organize the data we enter into a subform.

Each type of field allows a different method to enter the data. In many

if not all cases, more than one method can be used.

The first step to entering data in a form is to open it from the main

database window (Figure 183).

1) Click the Forms icon in the Database list.

2) Find the form’s name in the Forms list (Vacations).

3) Double-click the form’s name.

290 Getting Started with OpenOffice.org 3.x

Free eBook Edition

1 2 ... 285 286 287 288 289 290 291 292 293 294 295 ... 441 442

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