Comprehensive notes on Forms using wizard Class 10 IT 402

This article comprises comprehensive notes on Forms using wizard 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 Class 10 IT 402

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 OO 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 class 10 IT 402.

Observe the following screenshot I have Created a form:

[1] Step 1

forms and reports using wizard 10
forms and reports using wizard 10

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

Step 1 Form wizard in OO base

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

Step 5 Arrange Controls on form in OO base
Step 5 Arrange Controls on form in OO base

[4] Step 6 – Set Data Entry

Step 6 set data entry Form Wizard in OO Base
Step 6 set data entry Form Wizard in OO Base

[5] Step 7 – Apply Style

Step 7 Apply Styles Form wizard in OO base
Step 7 Apply Styles Form wizard in OO base

[6] Set Name

Step 8 Set Name form wizard in OO Base
Step 8 Set Name form wizard in OO Base

[7] Final output of Form

A form interface in OO base
A form interface in OO base

When you create forms using the wizard you will get some additional toolbars. These toolbars are our next topic for forms using wizard class 10 IT 402.

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 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

Add new record in table through form in oo base
Add new record in table through form in oo base

Step 2

Save newly added record
Save newly added record

In the next section of forms using wizard 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 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 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.
Search record using form
Search record using form

If you have missed any content of Information Technology follow this link:

Recommended – Information Technology

That’s all from forms using wizard class 10 IT 402. I hope you understand it well. If you have a doubt regarding forms using wizard 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.

Comment Your Views

%d bloggers like this: