Creating a Form Using a Wizard


graphics/05inf04.jpg

graphics/one_icon.jpg

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

graphics/two_icon.jpg

Double-click the Create form by using wizard option.

graphics/three_icon.jpg

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.

graphics/four_icon.jpg

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.

graphics/05inf05.jpg

graphics/five_icon.jpg

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

graphics/six_icon.jpg

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.

graphics/seven_icon.jpg

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

graphics/eight_icon.jpg

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.

graphics/05inf06.jpg

graphics/nine_icon.jpg

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 .

graphics/ten_icon.jpg

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.

graphics/eleven_icon.jpg

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

graphics/twelve_icon.jpg

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.

graphics/05inf07.jpg

graphics/thirteen_icon.jpg

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.

graphics/fourteen_icon.jpg

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

TIP

AutoForm Versus Wizard

The wizard offers the same layout choices as the AutoForm but provides additional choices on which fields you can include, as well as different styles.

TIP

Including Multiple Tables

For more complex forms, you can include fields from more than one table. You can also base a form on a query (queries are covered in Part 6). For more information, see Access's Help system.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net