How to Create Forms in Microsoft Access

Updated 2009-12-01 | Filed under Microsoft Access Tutorials | PDF

The following tutorial will provide a step-by-step process to create a form in Microsoft Access.

Estimated Time: 10 Minutes.

This tutorial will assume that you have an existing database with tables already created. If you are unsure of how to do this, follow our quick table tutorial.

Step 1: Open an existing database

First open an existing database which has a table that you'd like to collect information with. If you want to first learn how to create a table follow the steps on this tutorial. In my case I've opened my IT Department database which contains an IT Requests table.

Step 2: Click on Forms Tab

Under the Objects column, click on Forms.

Step 3: Click on the New button

To create a new form click on the New button right above the Objects column.

Step 4: Use the Form Wizard

There are several different ways to create a form. In this tutorial we will show you how to create a form using the Form Wizard. Select Form Wizard in the list and click 'OK'.

Step 5: Select data source and fields for the form

The next step in the wizard will ask you for the data source you'd like to use for the form as well as the fields. Once you'e selected the table you'd like to use as the data source you'll then be able to select the fields. Using the '>' button to select a single field, or use the '>>' button to select all the fields. Correspondingly use the '<' and '<<' buttons to unselect fields.
Once you've made your selections click 'Next'.

Step 6: Select a form Layout

The next step requires you to select a layout for the form. I'm going to select 'Justified' for my form layout. Feel free to select another layout that you may prefer and click 'Next'.

Step 7: Select a form Style

There are many different styles you can use for the form. Select the one of your liking. Click 'Next' to name your form.

Step 8: Name your Form

In the last step of this wizard you can name your form. You also now have the option of selecting:

  • Open the form to view or enter information: finish creating the form and launch it!
  • Modify the form's design: modify the design even more before saving.

You can also modify the forms design at any time by clicking on Design View. Click 'Finish' and you're done!

Congratulations on creating your form! If you're looking to distribute this form online to your various users you can follow our detailed instructions here.

Related Articles

Unrelated Articles