Create a Form with the Wizard

Create a Form Using the Form Wizard in Access

Access Training

Access Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Create a Form with the Wizard

You'll usually want to use the Form Wizard to create a form. It's almost easier to create and modify a form using the Form Wizard than it is to create one from scratch.

Create a Form Using the Form Wizard

  1. Click the Create tab on the ribbon.
  2. Click Form Wizard.
    Update Queries

    The Form Wizard appears. Anytime you create a form, you must tell Access which table or query you want to use for your form.

  3. lick the Tables/Queries list arrow and select the table or query you want to use to create your form.
  4. Click the Tables/Queries list arrow and select the table or query you want to use to create your form.
    Update Queries

    Now that you have specified the table, you need to tell the Wizard which fields you want to display on the form. To add a field to the form, you can either double-click the field or select the field and click the right arrow button.

  5. Double-click the fields that you want to appear on the form.
  6. Click Next.
    Update Queries

    Next the Form Wizard asks how you want to lay out the data on the form. There are a few different layout options:

    • Columnar: Displays one record at a time in a format that's easy to read.
    • Tabular: Displays multiple records at a time.
    • Datasheet: Displays multiple records at a time and looks like a table in Datasheet view.
    • Justified: Displays one record at a time. The format usually creates complicated forms that are difficult to work with.
  7. Select a layout option and click Next.
    Update Queries
  8. Enter a title for your form and click Finish.
    Update Queries

The Form Wizard creates the new form and displays it on screen.