Comprehensive notes on Forms using wizard in Base Class 10 IT 402

This article comprises comprehensive notes on Forms using wizard in Base Class 10 IT 402. This topic is one of the learning outcomes of Unit 3 Database Management Class 10 for IT 402 subject.

Forms using wizard in Base

Forms and reports are key features of DBMS. Both are used to improve user experience and customer interactions. So first we will discuss forms and then reports.

Forms in Base

Basically, forms are used to collect data from the user. It provides an interface to enter the data from the user side. In the database, forms help to store data into the database directly from the interface. By using forms user can view, enter, and change the data directly in the database. So now learn how to forms using wizard class 10 IT 402 in LibreOffice base for the learning outcome forms and reports using wizard 10.

Creating a form using the wizard

To create a form using wizard follow the given steps:

1. Click on Forms option available at the database objects pane/window.
2. Now click on the option “Use wizard to create form…” in the tasks window. The form wizard will appear.
3. This form wizard has 8 steps:
   1. Field selection – Select the field you want to display on the form
   2. Set up subform – This option allows to show the contents from the table with a separate form. There are two options available for this step:
      1. Subform based on the existing relation
      2. Subform based on manual selection of fields
   3. Add subform fields – This option only comes when you click on Add Subform option to select fields for the subform.
   4. Get joined fields – This option also related to subform and appears only when you select Add Subform option.
   5. Arrange Controls – This option allows to arrange available form controls. It provides three options like:
      • Label placement – Align Left or Align right,
      • Arrangement of the main form as: Columnar – Labels at Left, Columnar – Labels on Top, As Datasheet, In blocks – Label Above
      • Arrangement of subform – Columnar – Labels at Left, Columnar – Labels on Top, As Datasheet, In blocks – Label Above
   6. Set Data Entry – This option provides two options:
      • The form is to be used for entering new data only. Existing data will not be displayed.
      • The form is to display all data
        • do not allow modification
        • do not allow deletion
        • do not allow the addition
   7. Apply Styles – This step allows to apply formatting to the form. You can select a colour and border styles for the form.
   8. Set Name – This option allows setting the name for the form. You can give a new name, by default it will show the table name in the box. After then you can select one option like work wth the form or modify the form.

Steps explained with the screenshot for Forms using wizard in Base class 10 IT 402.

Steps for creating forms in LibreOffice base:

[1] Click on Forms from Database Pane in LibreOffice Base.

[2] Click on Use wizard to Create Form…

[3] A form wizard appears. Select desired query or table from which a form is going to be developed. Here I have selected EMP table.

[4] Select fields to be displayed on form. Click on Next button.

[5] Now wizard shows a step to display a sub form. Click on Next.

[6] One step Get joined fields will be skipped. and Arrange Control will appear.

[7] Select the Label Placement and arrangement of main form. I have selected Columnar – Labels left. Click on Next.

[8] Select Data Entry options as I have selected – This from is to display all data. Click on Next.

[9] Apply the desired style for your form. I have selected Bright Blue and 3-D look. Click on Next.

[10] This is last step of creating form. Type the form name and select the option to what do you want to do with form after creating the form, I have selected Work with the form option. Finally save your form.

[11] Click on Finish. Your form ready and to be displayed immediately as follows:

Observe the following screenshot I have Created a form in OpenOffice Base:

[1] Step 1

[2] Step 2 – Step 1 of Form wizard field selection. Here I have selected fields

I have not used any subform in this lab activity so directly I jumped to Step 5 – Arrange Controls.

[3] Step 5 – Arrange Controls: Left Align, Columnar – Labels left

[4] Step 6 – Set Data Entry

[5] Step 7 – Apply Style

[6] Set Name

[7] Final output of Form

When you create forms using the wizard you will get some additional toolbars. These toolbars are our next topic for Forms using wizard in Base.

The form window appears with few toolbars:

1. Form Control – Available vertically at the left side
2. Form navigation – Available at the bottom
3. Form Design – Available below the form navigation
4. Drawing – Adjacent to form design

Lets we discuss options to enter or remove data from forms for Forms using wizard in Base for class 10 IT 402.

Options to enter or remove data from forms

When you complete all the steps of form wizard, you will get a form navigation toolbar at bottom of the form window. In this form navigation, you will get Add New record icon. Click on it and you are allowed to type a new record. Save the record. Observe the following screenshots:

Step 1

Step 2

In the next section of Forms using wizard in Base class 10 IT 402 we will discuss about modifying forms.

Modifying Form

Modifying form is a simple process. Click on the record box whatever you want to modify and then save the record. To navigate through different records use form navigation control and modify it.

Now lets talk about changing the label and background for the topic Forms using wizard in Base class 10 IT 402.

Changing Label and background

The form created through the wizard is not allowing to modify the labels directly, because the displayed label and text box showing the field value are grouped together by default. Ungroup them first and then you can change it. Follow these steps:

1. Right-click on the displayed field value in the form.
2. Choose Group > Ungroup.
3. Now click on the double click on the label.
4. Field label properties will open.
5. Find the label text and type your desired text. Now close the properties window.
6. Adjust the label accordingly.
7. Save the form.

In a similar manner you can change the background, just select the background as you want from the properties. Watch the video to understand it.

The next section of Forms using wizard in Base class 10 IT 402 will talk about searching record using forms.

Searching records using the form

To search a record using form, follow these steps:

1. Click on Find Record button from the navigation toolbar. A new dialog box appears with the title “Record Search”.
2. Type text you want to search in the search for option and in the box available at the front of Text.
3. Select the fields whether all the fields or single field from the box. Apply the desired settings and click on search button.
4. Now the record that you have searched, will be displayed on the screen.

Follow this link to refer NCERT solutions chapter 12 create forms and wizard.

Follow this link for more important questions creating forms in wizard.

For more details on forms in LibreOffice Base, follow this link:

LibreOffice Forms Chapter 4 Forms in official LibreOffice Base website.

That’s all from Forms using wizard in Base class 10 IT 402. I hope you understand it well. If you have a doubt regarding Forms using wizard in Base class 10 IT 402 you can ask in the comment section. You can share your feedback using the comment section as well.

Hit the like button and share this article with your friends.

Thank you for coming to my blog website.