How to Create a Form with the Form Wizard in Microsoft Access
See Microsoft Access: Tips and Tricks for similar articles.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.
- On the Create tab in the Forms group, click Form Wizard. The wizard starts.
- 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.
- 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 >>.
- Click Next >.
- 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.
- Click Next >.
- Enter a title for the form.
- 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).
- Click Finish. The form loads in the view you selected.
Related Articles
- How to Create a Form with the Form Wizard in Microsoft Access (this article)
- How to Create a Report with the Report Wizard in Microsoft Access
- How to Add a Header and Footer to a Form in Microsoft Access
- How to Add a Header and Footer to a Report in Microsoft Access
- How to Open a Table in Design View in Microsoft Access
- How to Rename a Table in Microsoft Access
- How to Move a Field in the Query Grid in Microsoft Access
- How to Create a Navigation Form in Microsoft Access
- How to Add a Logo to a Form Header in Microsoft Access
- How to Add a Title to a Form Header in Microsoft Access
- How to Set the Navigation Form as the Default Form in Microsoft Access
- How to Run a Macro from a Navigation Button in Microsoft Access
- How to Add a Title to a Report Header in Microsoft Access
- How to Add a Logo to a Report Header in Microsoft Access