How to Create a Form with the Form Wizard in Microsoft Access

See Microsoft Access: Tips and Tricks for similar articles.
Looking to improve your Microsoft Access skills? Check out Webucator’s Microsoft Access classes.

The Form Wizard gives you more control over your results than one-click forms do. The wizard lets you make decisions about certain aspects of a form's design and produces a form based on your instructions. To create a form based on a single table using the Form Wizard, follow these nine steps.

This feature works the same in all modern versions of Microsoft Access: 2010, 2013, and 2016.

  1. On the Create tab in the Forms group, click Form Wizard. The wizard starts. Form Wizard
  2. From the Tables/Queries drop-down list, select the table (or query) to base the form on. The fields for the selected table load in the Available Fields list box.
  3. Move the fields to include on the form from the Available Fields list box to the Selected Fields list box. To do so, double-click a field name to move it or highlight the field name and click >. To move all fields at once, click >>. Form Wizard
  4. Click Next >. Form Wizard
  5. Select the layout for the form. Your options are "Columnar", "Tabular", "Datasheet", and "Justified".

    Tip: Select each of the options to see a preview of the form layout before you make a final selection.

  6. Click Next >. Form Wizard
  7. Enter a title for the form.
  8. Select an option for the view you want to open the form in. Your options are:
    • Open the form to view or enter information (opens in Form view).
    • Modify the form's design (opens in Design view).
  9. Click Finish. The form loads in the view you selected. Form ViewDesign View

Related Articles

  1. How to Create a Form with the Form Wizard in Microsoft Access (this article)
  2. How to Create a Report with the Report Wizard in Microsoft Access
  3. How to Add a Header and Footer to a Form in Microsoft Access
  4. How to Add a Header and Footer to a Report in Microsoft Access
  5. How to Open a Table in Design View in Microsoft Access
  6. How to Rename a Table in Microsoft Access
  7. How to Move a Field in the Query Grid in Microsoft Access
  8. How to Create a Navigation Form in Microsoft Access
  9. How to Add a Logo to a Form Header in Microsoft Access
  10. How to Add a Title to a Form Header in Microsoft Access
  11. How to Set the Navigation Form as the Default Form in Microsoft Access
  12. How to Run a Macro from a Navigation Button in Microsoft Access
  13. How to Add a Title to a Report Header in Microsoft Access
  14. How to Add a Logo to a Report Header in Microsoft Access