Introduction to Forms

Help Center > Microsoft Access > Introduction to Forms

Forms are another way to enter data into the database table. They can take the appearance of actual paper forms and can make it easier for those unfamiliar with databases to input data.

Create a Form Using the Form Wizard

formWizard

To create a form using the Form Wizard, follow these steps:

  1. Click the Create form by using wizard option on the database window.
  2. From the Tables/Queries drop-down menu, select the table or query the form will modify. Then select the fields that will be included on the form by moving them from the Available Fields list to the Selected Fields list. The button with the single > button will move only the selected fields, the double >> button will move all of the available fields. After the fields you want to inclued have been selected, click the Next button.
  3. On the second screen, select the layout of the form.
    • Columnar - labels and form fields listed side-by-side in columns
    • Justified - labels and form fields are listed in a row across the screen
    • Tabular - Multiple records are listed with fields and records arranged in columns and rows
    • Datasheet - Multiple records are displayed in a manner simillar to an Excel worksheet

    Click the Next button to move on to the next screen.

  4. Select a graphical style for the form from the next set of options and click Next .
  5. On the final screen, name the form. Click Finish to create the form.

Adding Records Using A Form

Input data into the table by filling out the fields of the form. A new record can be created by clicking the "New Record" button at the bottom of the form window. Records are automatically saved as they are entered.

form
last modified on 06/27/2007 17:02