Ina previous Post I showed you how to create a database in OpenOffice/NeoOffice Base. The follow up to that post showed you how to create a table using the table Wizard. Well this is a follow up post showing you how to create a form for data entry in OpenOffice Base, which I will will do after the break.

We start off creating the form by showing the forms section of the window for the Base database. We double click on “Use Wizard to Create form.” This brings up the Form Creating Wizard dialog.

the first window is all about what fields you want to see on the form. Move the field you want from the list ont he left to the list on the right. Order is important as that will be the order it uses to build the form. To Move all the field at one use the >> button. << moves all the fields off the right hand list. When you have the fields you want on the right list click next.

Click on the arrangement you want on your form. Then click next.

Choose whether this form is just for data entry, or if it can be used to both display and data entry.

Choose a style for the form, both color and border styles. Click next.

Give your form a name. Make the name unique. Click on finish.

You now have a form for your table in your database. If you chose to allow multiple uses for your form, you can enter data, move to the next record and enter the next set of information. It works like MS Access forms, in that the data is committed to the database when you move to a different record.
Once you’ve used the wizard to make the form you can enter design view of the form and move controls around. The screen shots are of NeoOffice, but the OpenOffice product works the same. You don’t have to put up with MS Access, or pay the price for that product. OpenOffice Base is aailable for you to build your desktop database needs.
Related posts:
{ 1 trackback }