How to create a form for data entry in OpenOffice Base

by Clay Moore on February 11, 2010

in Computers,Database,How to

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.

Screenshot2010-02-10at7.09.02PM.png

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.

Screenshot2010-02-10at7.10.17PM.png

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.

Screenshot2010-02-10at7.13.02PM.png

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

Screenshot2010-02-10at7.13.30PM.png

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

Screenshot2010-02-10at7.13.43PM.png

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

Screenshot2010-02-10at7.13.56PM.png

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

Screenshot2010-02-10at7.14.14PM.png

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.

  • Share/Bookmark

Related posts:

  1. The data types in an OpenOffice Base Database
  2. How to create tables in OpenOffice(NeoOffice)
  3. How to Create Reports in OpenOffice Base
  4. Creating trouble-free Tables in OpenOffice Base
  5. Creating Databases with OpenOffice

Leave a Comment

{ 1 trackback }

Previous post:

Next post:

<