Bradley University Skip repetative navigation
 
Microsoft Access

Forms

A form is a graphical interface of a table. You can add, update, delete records in your table by using a form and ensure data is protected from accidents.

Forms are recommended when there are numerous fields in a table. All fields are displayed one screen, unlike in the table view (datasheet) you would have to scroll to get the field you desire.

NOTE: Although a form can be named different from a table, they both still manipulate the same information and the same exact data. If you change a record in a form, it will be changed in the table also.

Create a Form using the Wizard

It is a very good idea to create a form using the wizard, unless you are an advanced user and know what you are doing. Microsoft Access does a very good job of creating a form using the wizard. The following steps are needed to create a basic form:

  1. Switch to the Database Window. You can do this by pressing F11 on the keyboard.

  2. Click on the Forms button under Objects on the left side of screen.

  3. Double click on Create Form Using Wizard.

 


  1. Select the fields to view on the form. Most of the time you would select all of them.

  2. Click Next.

 


  1. Select the layout you wish.

  2. Click Next.

 


  1. Select the style you desire...HINT: if you plan on printing your form, I suggest you use a light background to save on printer toner and ink.

  2. Click Next.


  1. Give you form a name, and select Open the Form and enter information.

  2. Select Finish.

 


Table1 form created using the wizard.  


Go back to the top of the page Go back