Easy Microsoft Office Access 2003

After you open the database for which you want to create a form, click the Forms option in the Objects bar.

Double-click the Create form by using wizard option.

The Form Wizard starts. Click the down arrow next to the Tables/Queries field and select the table on which you want to base the form from the list that appears.

The Available Fields list catalogs all the fields in the selected table. Click the first field you want to appear in the form.

INTRODUCTION

AutoForms are great if you want your form to include all the available fields in the selected table in the order they appear in the table. If, however, you want your form to include only certain fields, or to include fields in a different order, you'll want to use Access's Form Wizard to create your form. The wizard enables you to select only those fields you want and to place them in any order you choose.

TIP

Selecting Fields

You do not have to select all the fields in your table. Keep in mind, though, that when you add a new record using a form, the fields that were not included in the form will be blank in those records.

Click the Add button (it's the one with a single right-pointing arrow on it).

The field is added to the Selected Fields list. Continue selecting and adding fields until all the necessary fields appear in the Selected Fields list.

When you finish selecting the fields you want to appear in your form, click the Next button.

The Form Wizard displays a list of available layouts for your form. Click a layout to preview it in the left side of the dialog box. When you find a layout you like, click Next .

TIP

Adding and Removing Fields

If you want to include all available fields in your form, click the button that contains two right-pointing arrows. To remove a field from the Selected Fields list, select it and click the left-pointing arrow button.

TIP

Listing Fields

The fields are listed in the order you add them. If you prefer a particular order, simply add the fields in the order you want.

The wizard presents a list of styles that affect how the form looks (such as its colors, background, fonts, and so on). Click a style to preview it. When you find one you like, click Next .

Type a name for the form in the What title do you want for your form? field; the form will be saved with this name.

Select whether you want to open the form immediately (shown here) or modify the form's design first.

Click Finish .

TIP

Saving the Form

When you use the Form Wizard to create a form, that form is saved automatically using the name you type for that form in step 10. You do need to save the form manually, however, if you make any changes to the form's design later.

Depending on your selection in step 11, Access displays the new form in Datasheet view (for viewing and entering records) or Design view (for changing the form's design). Click its Close button.

The form is listed in the database window; you can open the form again when you want to use it.