Microsoft Office Tutorials and References
In Depth Information
Creating a Form Using the Form Wizard
As you learned in Tutorial 1, a form is an object you use to enter, edit, and view records
in a database. You can design your own forms or have Access create them for you
automatically. In Tutorial 1, you used the Form tool to create the Contract Data form in
the Belmont database. Recall that the Form tool creates a form automatically, using all
the fields in the selected table or query.
Oren asks you to create a new form that his staff can use to view and maintain data in
the Customer table. To create the form for the Customer table, you’ll use the Form
Wizard. The Form Wizard allows you to choose some or all of the fields in the selected
table or query, choose fields from other tables and queries, and display the selected fields
in any order on the form. You can also apply an existing style to the form to format its
To open the Belmont database and start the Form Wizard:
1. Start Access and open the Belmont database located in the Level.01\Tutorial
Trouble? If the Security Warning is displayed below the Ribbon, click the Options
button next to the Security Warning. In the dialog box that opens, click the
“Enable this content” option button, and then click the OK button.
2. If necessary, open the Navigation Pane. To create a form based on a table or query,
you can select the table or query in the Navigation Pane first, or you can select it
using the Form Wizard.
3. In the Navigation Pane, click Customer : Table to select the Customer table as the
basis for the new form.
4. Click the Create tab on the Ribbon. The Forms group on the Create tab provides
options for creating various types of forms and designing your own forms.
5. In the Forms group, click the More Forms button, and then click Form Wizard .
The first Form Wizard dialog box opens. See Figure 4-1.
First Form Wizard dialog box
scrollable lis t
of fields in the