Form Wizard in MS Access

Form Wizard guides you through the process of creating a form without requiring you to design the entire layout manually.

Example: Student Admission Form

This is an illustrative form layout. Form Wizard creates the actual working form inside Microsoft Access.

Advantages of Form Wizard

• Creates forms quickly.
• Allows you to select only the required fields.
• Provides multiple form layouts.
• Reduces manual design work.
• Creates forms connected to tables or queries.

Before using Form Wizard, create a table containing the fields you want to display in the form.

Example: Students Table

Save the table as Students. You can now use it as the source for your form.

Follow these steps to open Form Wizard:

1. Open your Microsoft Access database.
2. Click the Create tab on the ribbon.
3. Find the Forms group.
4. Click Form Wizard.
5. The Form Wizard dialog box will appear.

In the wizard, you can select the table or query that contains the fields you want to use.

The first important step in Form Wizard is selecting the fields that should appear on the form.

Steps

1. Choose the required table or query from the Tables/Queries list.
2. Review the Available Fields list.
3. Select a field you want to include.
4. Click the single right-arrow button to move that field.
5. Use the double right-arrow button to move all available fields.
6. Use the left-arrow buttons to remove selected fields if needed.
7. Click Next when your field selection is complete.

Example Field Selection

You can choose all fields or only the fields required for the form.

After selecting fields, Form Wizard allows you to choose a layout for displaying the records.

Steps

1. Select the desired layout.
2. Preview the layout if the wizard offers that option.
3. Click Next to continue.

Depending on the Access version and wizard options, you may be able to choose a style for your form. You will also be asked to provide a form title.

Steps

1. Select a style if the option is available.
2. Click Next.
3. Enter a suitable form name.
4. For example, enter frmStudentAdmission.
5. Choose whether to open the form for viewing or open it for design changes, if prompted.
6. Click Finish.

Examples of Form Names

• frmStudents — Student details form
• frmStudentAdmission — Admission form
• frmCourses — Course details form
• frmFees — Fees details form

Use meaningful names so that you can identify each form easily in the Navigation Pane.

After clicking Finish, Access creates the form and opens it according to the option you selected.

Entering a New Record

1. Open the form in Form View.
2. Navigate to the New (blank) record.
3. Enter the student's details in the fields.
4. Move to another record or close the form to save the entry.
5. Open the Students table to verify the record.

Editing a Record

1. Open the form in Form View.
2. Navigate to the record you want to edit.
3. Change the required field values.
4. Move to another record to commit the change.
5. Verify the updated information.

You can customize a form after creating it with Form Wizard.

Using Layout View

• Adjust field widths and positions.
• Resize labels and text boxes.
• Change the overall layout while viewing data.

Using Design View

• Add or remove controls.
• Modify form sections.
• Change control properties.
• Customize the form's structure.

Steps to Open Design View

1. Close the form or open its tab.
2. Right-click the form in the Navigation Pane.
3. Select Design View.
4. Make the required changes.
5. Press Ctrl + S to save.

Create a Students table with StudentID, StudentName, FatherName, Course, Mobile, and Fees fields.

Tasks

1. Open Form Wizard from the Create tab.
2. Select the Students table as the data source.
3. Move StudentName, FatherName, Course, Mobile, and Fees into Selected Fields.
4. Choose Columnar layout.
5. Give the form the name frmStudentAdmission.
6. Finish creating the form.
7. Enter at least three sample student records.
8. Open the Students table and verify the records.
9. Open the form in Design View and adjust the layout.
10. Save the form and reopen it in Form View.

1. What is Form Wizard in MS Access?
2. Why do we use Form Wizard?
3. From which tab can you open Form Wizard?
4. How do you select fields for a form?
5. Name four common form layouts.
6. Which layout is generally suitable for entering one record at a time?
7. Why should forms have meaningful names?
8. How do you modify a form created with Form Wizard?
9. How can you verify that a new record was saved?
10. What should you check if a form does not allow editing?