Creating Forms for Simplified Data InputEven if You re Not a Programmer


Creating Forms for Simplified Data InputEven if You're Not a Programmer

In the last part of this chapter, we'll create a simple form that you can use to view and edit data in your database.

Start OOo Base, connect to the database, and click the Form icon in the Database pane.

The main Base forms screen.

In step 1 you choose the fields you want to use in the form. Click the double right arrow to select all the fields in the list; they are transferred from the left pane to the right one. Click Next.

Moving fields from the left pane to the right.

To set up a subform, enable the Add Subform radio button in step 2. In the example, Next was just clicked.

Setting up a subform screen.

Steps 3 and 4 pertain to subforms. Because you didn't add any, you can ignore them.

Step 5 gives you the option of several form layouts for the labels and fields. They can be arranged in various spreadsheet or columnar styles. Click Next.

The Arrange Controls screen.

Use step 6 if you want your form to allow only new data input. You can also select how your data will be displayed. Click Next.

Selecting how the form and data are displayed.

The form's background color and whether it's flat or 3D can be set in step 7. A cool blue color called Ice Blue was chosen for the example and is shown behind the wizard screen. Click Next.

Viewing the sample form with the Ice Blue background.

Finally, step 8 gives you a place to type in a form name. Saving the form lets you come back later and reuse it. Click Finish.

Saving the form with a name.

The form is now complete. If you have write access to the database, you can view and edit data.

The completed form.

You can use the arrow keys at the bottom to move back and forth through the records.




Point & Click OpenOffice. org.
Point & Click OpenOffice.org
ISBN: 0131879928
EAN: 2147483647
Year: 2003
Pages: 143
Authors: Robin Miller

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net