10 Minute Guide to Microsoft Access 2002
By Joe Habraken
Table of Contents
Lesson 12. Creating a Simple Form
Creating a Form with the Form Wizard
The Form Wizard offers a good compromise between the automation of AutoForm and the control of creating a form from scratch. The wizard allows you to select the fields for the form and select +the layout and look for the form. Follow these steps to use the Form Wizard:
From the database window, click the
Create Form by Using Wizard
to open the Form Wizard (see Figure 12.3).
Figure 12.3. The Form Wizard enables you to choose which fields you want to include from as many different tables in the database as you like.
From the Tables/Queries drop-down list, choose a table or query from which to select fields. (By default, the first table in alphabetical order is selected, which probably isn't what you want.)
Click a field in the Available Fields list that you want to in clude on the form, and then click the
) button to move it to the Selected Fields list.
Repeat step 4 until you've selected all the fields you want to include from that table. If you want to include fields from another table or query, go back to step 3 and choose another table.
Selecting All Fields
You can quickly move all the fields from the Available Fields list to the Selected Fields list by clicking the Add All (
) button. If you make a mistake, you can remove a field from the Selected Fields list by clicking it and then clicking either the Remove (
) button or the
to continue. You're asked to choose a layout:
. Click each button to see a preview of that type (Columnar is the most common). Select the layout you want to use, and then click
The next screen asks you to select a style for your form (see Figure 12.4). Click each style listed to see a preview of it; click
when you've selected a style.
Figure 12.4. You can select from several form styles.
On the last screen, enter a title for the form into the text box at the top of the dialog box (if you want a title other than the default).
button. The form appears, ready for data entry (see Figure 12.5).
Figure 12.5. The Form Wizard creates a usable form using the fields, format, and style that you selected.
If your form's field labels are cut off or need some additional layout work, you can fix them in the Form Design view. You learn about modifying a form in Lesson 13, "Modifying a Form."