Forms

A form is nothing more than a graphical representation of a table. You can add, update, delete records in your table by using a form. NOTE: Although a form can be named different from a table, they both still manipulate the same information and the same exact data. Hence, if you change a record in a form, it will be changed in the table also.

A form is very good to use when you have numerous fields in a table. This way you can see all the fields in one screen, whereas if you were in the table view (datasheet) you would have to keep scrolling to get the field you desire.


Back to top

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
  4. On the next screen select the fields you want to view on your form. Most of the time you would select all of them.
  5. Click Next
  6. Select the layout you wish
  7. Click Next
  8. 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
  9. Click Next
  10. Give you form a name, and select Open the Form and enter information
  11. Select Finish
  12. You should see your form. To adjust the design of your form, simply hit the design button (same as with the tables), and adjust your form accordingly