Creating Forms in MS Access

A form is a database object that allows users to work with data in an organized layout. Forms are commonly connected to tables or queries.

Example: Student Admission Form

This is only a visual example of a form layout. To create a working form, build it inside Microsoft Access.

Advantages of Forms

• Make data entry easier.
• Provide an organized interface.
• Reduce direct interaction with tables.
• Allow users to view and edit records.
• Support controls such as buttons and drop-down lists.

The Form button is the quickest way to create a form based on an existing table or query.

Steps to Create a Form

1. Open your MS Access database.
2. In the Navigation Pane, select the Students table.
3. Click the Create tab.
4. Click the Form button in the Forms group.
5. Access automatically creates a form using the selected table.
6. Review the form and its fields.
7. Press Ctrl + S to save the form.
8. Enter a name such as frmStudents.

A Blank Form provides an empty form layout that you can customize by adding fields and controls.

Steps

1. Open your database.
2. Click the Create tab.
3. Select Blank Form.
4. Access opens an empty form.
5. Open the Field List if it is not visible.
6. Drag the required fields onto the form.
7. Arrange the controls as needed.
8. Save the form with a meaningful name.

Blank Forms are useful when you want more control over the layout and placement of fields.

The Form Wizard helps you create a form by selecting fields and choosing a layout.

Steps to Use Form Wizard

1. Click the Create tab.
2. Select Form Wizard.
3. Choose the required table or query.
4. Select fields from the Available Fields list.
5. Move the required fields to Selected Fields.
6. Click Next.
7. Choose a layout, such as Columnar or Tabular.
8. Click Next and choose a style if prompted.
9. Enter a form title.
10. Click Finish.

Common Form Layouts

Access provides different views for working with forms. Each view has a different purpose.

How to Change the View

1. Open the form from the Navigation Pane.
2. Right-click its tab or title.
3. Select the required view from the available options.

You can also use the View button on the ribbon when working with a form.

Controls are objects placed on a form to display information, accept input, or perform actions.

A form connected to a table can be used to enter new records and edit existing records, depending on its settings and permissions.

Entering a New Record

1. Open the form in Form View.
2. Move to the New (blank) record using the record navigation controls.
3. Enter the required field values.
4. Move to another record or close the form to save the record.
5. Open the table to verify that the record was saved.

Editing an Existing Record

1. Open the form in Form View.
2. Navigate to the required record.
3. Click the field you want to change.
4. Edit the value.
5. Move to another record to commit the edit.

Save a Form

1. Open the form in Design View or Layout View.
2. Press Ctrl + S.
3. Enter a name if the form has not been saved before.
4. Click OK.

Rename a Form

1. Close the form if it is open.
2. Find the form in the Navigation Pane.
3. Right-click the form name.
4. Select Rename.
5. Enter the new name and press Enter.

Use descriptive names such as frmStudents, frmAdmissions, and frmCourseDetails.

• Use clear labels for every input field.
• Arrange related fields together.
• Use combo boxes for fixed lists such as courses.
• Keep the form layout simple and readable.
• Use meaningful names for forms and controls.
• Test data entry and editing before sharing the database.
• Set validation rules on the table or form where appropriate.
• Restrict editing when users should only view records.

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

Tasks

1. Create a form using the Form button.
2. Create another form using Form Wizard.
3. Create a Blank Form and add selected fields.
4. Save the forms as frmStudents and frmStudentAdmission.
5. Open the form in Form View.
6. Add a new student record.
7. Edit an existing student's course or fees.
8. Open the table to verify the changes.
9. Switch between Form View, Layout View, and Design View.
10. Practice arranging labels and text boxes in Design View.

1. What is a form in MS Access?
2. What are the advantages of using forms?
3. How do you create a form using the Form button?
4. What is the purpose of Form Wizard?
5. What is the difference between Form View and Design View?
6. What is Layout View used for?
7. What is a text box control?
8. What is the purpose of a combo box?
9. How do you save a form?
10. How can you rename a form in the Navigation Pane?