

Scroll down to and click on the Action drop-down list. There you input add record in the Label box to change the button’s text. Right-click the button on the left, and select the Control option to open the window below. Position them at the bottom of the form as below. There you should select the Push Button option on the left, and then drag out a couple of rectangular buttons, roughly of the same size, with the cursor. Right-click on the database form, and then select Edit to open the form editing window. However, you can still add more to the form from the design view. What the above form lacks is add and remove record buttons. Then you should have a form comparable to the one below. Add the title Database Form on step eight, and click Finish to close the wizard. You can choose a variety of alternative styles for your form, such as Beige, Orange and Ice Blue, on the seventh step. In the final few steps of the of the wizard you should select The form is to display all data option on step six.

Select Columnar – Labels Left options for both the main form and the subform as in the shot below. On the fifth step, choose a suitable arrangement for the main form. Then click Next to move to the wizard’s fifth step. Click on the double arrow to add all the Setup Details table fields to the subform. Select Setup Details and Next to choose the fields for your subform. Click the Add subform and Subform based on existing relation options. On the next step you should click the Add subform check-box option. Click on the double arrow to select all the table’s fields, and select Next to go to step two. On the first step of the wizard click the drop-down list, and select the Software Details table. Then click on Forms > Use Wizard to Create Form to open the window below. Click Finish to open both the primary Base window and the software database. From the Database Wizard window, select Open an existing database file and then select its file from the drop-down list below. Open the database, in Base, set up in the previous article. OpenOffice Base, like most database packages, has options with which you can set up database forms. Of course, you can input software records directly into those database tables but it’s better to add a data entry form from which you can enter the records. In part one of our guide on how to setup OpenOffice Base database, we covered how you can set up the tables for a software database.
