OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources]

Greg Perry, M. T. Cozzola, Jennifer Fulton

نسخه متنی -صفحه : 231/ 175
نمايش فراداده

139. Enter Data Using a Form

137 Create a Form

138 Modify a Form

136 Enter Data in List View

After creating a form, you can use it to add data to the table that's associated with the form. You might have added controls to make data entry easier, such as a list box with entries from which a user can choose. Or you might simply have reorganized the fields on the form so that they follow a more natural flow. In any case, in this task, you'll learn how to use your form to enter data into its table.136 Enter Data in List View .

1.

Click Forms

To add data to a table using a form, you must open the form first. Click the

Forms icon in the

Database pane of the Base window. A list of forms associated with the current database appears on the lower-right side of the window.

2.

Double-Click Form

In the

Forms list, double-click the form you want to use to enter data. The form opens, ready for you to add data. On the

Form Navigation toolbar at the bottom of the screen, the current record number is displayed, along with a total of the records in the table.

3.

Enter Data in Record

If the table already has data in it, the data for the first record might be currently displayed in the form fields. If so, you need to clear the fields and start a new record so that you can enter new data. To do that, click the

New Record button on the

Form Navigation toolbar.

Enter data in the first field. If the first field is an

auto value , its value will be automatically updated for each record you create, so skip that field. Press

Tab to move to the next field, and enter its data. Continue this process to enter data for the entire record.

139. Enter Data Using a Form

[View full size image]

NOTES

You can skip any fields that do not apply to the current record by pressing

Tab to bypass them.

If you have to make changes to an existing record, display that record by clicking the

< or

> buttons on the

Form Navigation toolbar. Then make your changes and press

Tab to advance to the next record. To remove the record from the table, click the

Remove Record button (the red X) on the

Form Navigation toolbar.

4.

Press Tab to Begin New Record

Press

Tab after entering data in the last field of the record; the record is saved and a new blank record appears.

Do this even if you don't want to add a new record, because pressing

Tab

after the last field in a record also saves the last record. If you want to enter data for another record, repeat steps 3 and 4.

5.

Close Form

When you're through entering data, close the form by clicking the

X in the upper right corner of the window. If you pressed

Tab after entering data in the final record, you won't be prompted to save the table because each record you added has already been saved to the database. If prompted, however, click

Yes to save the table.