Skip to main content.

Access 2007

Create Access Forms

Forms are excellent way to input data or search for data in an Access table or query.

To create a form using the Form Tool:

1. In the Navigation Pane, select the table or query you want for which you want to create the form.

2. Click Form in the Forms Group under the Create Tab.

forms group

3. The form appears in Layout View showing the first record using all of the fields in the table.

customer list form

Note:  Layout view is the most intuitive view to use for form modification, and it can be used for nearly all the changes you would want to make to a form in Office Access 2007. In Layout view, the form is actually running, so you can see your data much as it will appear in Form view. However, you can also make changes to the form design in this view. Because you can see the data while you are modifying the form, this is a very useful view for setting the size of controls or performing almost any other task that affects the appearance and usability of the form.

Create a Form Using the Forms Wizard

To be more selective about what fields appear on your form, you can use the Form Wizard instead of the various form-building tools previously mentioned. You can also 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. For more information about creating relationships, see the links in the See Also section of this article.

  1. On the Create tab, in the Forms group, click More Forms, and then click Form Wizard. Button image
  2. Follow the directions on the pages of the Form Wizard.

     Note:   If you want to include fields from multiple tables and queries on your 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 click any additional fields that you want to include on the form. Then click Next or Finish to continue.

  3. On the last page of the wizard, click Finish.

Add Design to Your Form

When the form appears, the Form Layout tolls tabs, Format and Arrange, appear. This allows you to customize the appearance of the form. You can apply a theme from the Auto Format group, You can a title or even a logo in the Controls Group. You can play with fonts in the Fonts Group. Basically, you can make the form your own creation. See below:

formatted form