
Chapter 7: Databases and Data Sources
Viewing Data
The database still does not have a convenient way to view the appointments it stores. We
could look at the table itself but this is neither attractive presentation nor good database
design. Additionally, because the New Appointment form is a data entry form, we cannot use
it to view previously entered records.
Since a lot of time and effort was put in to creating the New Appointment form and its format
is also good for viewing data, the following sections will discuss copying a form and
changing some of the properties of the new form.
Copying the form
1. In the Forms section of the database, right-click the New Appointment form.
2. Click Copy.
3. Right-click in the database window and choose Paste.
4. In the dialog box that appears, enter All Appointments for the form name and click
OK.
5. Save the database.
Changing the form's properties
Obviously, since the New Appointment form was a data-entry only form, we will need to
change the related form property.
1. Right-click the All Appointments form and choose Edit.
2. Click the Form Navigator button on the Form Design toolbar. This toolbar is
generally found at the bottom of the OpenOffice.org Writer window. (Writer is the
application used to edit forms in OpenOffice.org.)
3. In the Form Navigator dialog, right-click the Main Form item and choose
Properties.
4. On the Data tab of the Properties dialog, set the Add data only property to No.
5. Close the Properties dialog.
6. Close the Form Navigator.
7. Save the form.
8. Click the Design Mode On/Off button on the Form Design toolbar.
You can now use the Form Navigation toolbar to navigate through the records in the
database.
Setting a sort order for a form
The records are currently in the order in which they were added to the database. This, in the
long run, is not very useful. Adding a sort order to the form will make it more useful for
viewing all the appointments in the database.
OpenOffice.org User Guide for 2.x 372
Comentarios a estos manuales