Access provides several quick-create form tools on the Create tab, each of which lets you create a form with a single click. However, if you want to be more selective about what fields appear on the form, you can use the Form Wizard instead. The wizard also lets you define how the data is grouped and sorted, and you can use fields from more than one table or query (provided that you specified the relationships between the tables and queries beforehand).
Note: This article doesn’t apply to Access web apps – the kind of database you design with Access and publish online.
Start the Form Wizard
On the Create tab, in the Forms group, click Form Wizard. Note, if you're using Access 2007, on the Create tab, in the Forms group, click More Forms, and then click Form Wizard.
Follow the directions on the pages of the Form Wizard.
Note: If you want to include fields from multiple tables and queries on the form, do not click Next or Finish after you select the fields from the first table or query on the first page of the Form Wizard. Instead, repeat the steps to select a table or query, and then click any additional fields that you want to include on the form. Then click Next or Finish to continue.
On the last page of the wizard, click Finish.
The Form Wizard can create a variety of results depending on the options that you select. As a result, we recommend that you run the wizard several times, experimenting with different options each time, until you get the results that you want.
For more information about how to create relationships, see the article Create, edit or delete a relationship.