CREATE FORMS AND REPORTS USING WIZARD

 Creating Form Using Wizard

To create a form, Click on Forms option located under Database section

Steps To Create Form Using Wizard

Click Use Wizard to Create Form. option under Tasks group. The Form Wizard dialog box appears as shown below. You can select selective fields to be sent onto the form by selecting the field name and clicking >button. You can select individual fields in a database or all fields in a database To use all the fields in the table in a form, click the >> button. Notice the fields displayed under Fields in the forms section. Click Next >. You see the Set up a sub form step dialog box of the wizard as shown below. You can select the option Add Subform if you need to insert the contents in the table in a separate form. Click Next>. Now you need to arrange selected fields in a form. You can use different styles from the list displayed below: Once you have selected a style, click Next > A dialog box appears wherein you can select the data entry model. Click Next >. You should see a dialog box wherein you can specify the styles to be used in the form. Click Next >. You see a dialog box where you can specify the name of the form. Click Finish. A form window appears. Notice that the records in the table are displayed automatically within the form that you just created.

Options To Enter Data From Forms

You can add new records to the table using the form by clicking the symbol located at the bottom as shown below. Once you click the symbol, you will be displayed with a window for creating records. You have learnt to create records using design view in the earlier sessions. You can add records using the form as displayed below. Type the following data in the textbox provided in the box as shown below: To view the saved records, Double-click SDetails (Table name) under Tables section. A window similar to the one below will be displayed; notice the record that you created using a form is also displayed along with other records. Now enter three more records using the form and view them using the above mentioned procedure.

Reports

A report helps to display the data in a summarized manner. It is used to generate the overall work outcome in a clear format. You can create reports in the database.

Creating Reports using wizard

Reports helps to get the summarized data. To create reports in Base, the table must be

selected from using which data can be displayed in a format as required.

The steps to create followed are :

 Click on Reports section under Database in the OpenOffice base application.

 Once you select the option, you should see a window similar to the one displayed

below. Now we can generate the report for the table created earlier. Click on Use Wizard to Create Report... option available under Tasks. Once you select the Use Wizard to Create Report... option. You should see a window similar to one displayed below. You have to select all the table fields by selecting the >> button, once you click the button >> you should see a dialog box similar to the one displayed below. Once you click Next>.you should see a dialog box similar to the one displayed below. You can redefine the label of the fields in the reports or else you can set the default name. Once you click Next >, you should see a dialog box similar to the one displayed below. You can define grouping for the fields of the table. Once you click Next >, you should see a dialog box similar to the one displayed below. You can sort the field variables in the report by selecting the appropriate field and sorting method. Once you click Next >, you should see a dialog box similar to the one displayed below. You can select the layout of the report by selecting the appropriate option available under the Layout of data down list and you can also select the orientation of the report. Once you click Next >, you should see a dialog box similar to the one displayed below. You can define a name for the report or you can use the name of the table itself for the report also. Click Finish. Once you click Finish you should see a window similar to the one displayed below with the report. Now create a report containing only Name, RollNo and Phone details. Use different layouts for the report design.