OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 402)

Chapter 7: Databases and Data Sources

1. In the database window, click the Forms icon on the left side.

2. Click the Use Wizard to Create Form button.

3. The Form Wizard opens to Step 1, Field Selection. Click the Tables or queries

drop-down and choose Table: Appointments.

4. Move all the fields except ID to the Fields in the form list by clicking the > button

for each desired field.. Click Next.

5. Step 2, Set up a subform, is not needed for this form since we will not be including a

subform. Simply click Next.

Note: A subform allows the user of a database to access related data. For example, if multiple types were allowed

per appointment, they might be displayed in a subform.

6. The wizard automatically skips steps 3 and 4 since they are related to subforms.

7. Step 5, Arrange controls, allows the designer to choose a rough, basic layout for the

form controls. This choice is open to preference but in creating the sample database,

we chose In Blocks – Labels Above, the fourth option. Click Next.

8. Step 6, Set data entry, is where the designer of the database can narrow the use of a

form. In this example, this is a new appointment form so we only want user to be able

to enter data. Set the option here to The form is to be used for entering new data

only. Existing data will not be displayed. Click Next.

9. Step 7, Apply styles, is also open to personal preference. The Flat field border style

does have some nice built-in visual effects and was chosen for the example database.

We also chose Ice Blue as the style. Click Next after selecting the options.

10. Step 8, Set name, allows us to name the form. Enter New Appointment for the

name.

11. Set the option to Modify the form and click Finish.

12. The form opens to edit mode, as opposed to data entry mode. Now the form can be

modified.

Making data entry easier

The easiest thing to do to simplify data entry is to move the fields around. This can be done

by clicking and dragging the fields while the form is in edit mode. The following sections

detail other ways to simplify data entry. These example steps assume that the New

Appointment form is open in edit mode.

Modifying a date field

A text box that is related to a date field can very easily be turned in to a date picker control.

1. Click once on the Start Date field.

2. Right-click the field and choose Group > Edit Group.

OpenOffice.org User Guide for 2.x 368

1 2 ... 397 398 399 400 401 402 403 404 405 406 407 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 402