Creating a Form Using a Wizard

graphics/microsoft98.gif

To create a simple form in Access, you can use one of the AutoForm wizards. These wizards quickly arrange the fields from the selected table or query into an attractive form. In a form created with the AutoForm: Columnar Wizard, you see each record's data displayed vertically, and with the AutoForm: Tabular Wizard, you see each record's data horizontally. With the AutoForm: Datasheet Wizard, the form displays the records in Datasheet view. After you create a form, you can save and name it so that you can use it again. If you need a more custom form, you can use the Form wizard to select the information you want to include from a variety of places.

Create a Custom Form Using the Form Wizard

graphics/one_icon.jpg

In the Database window, click Forms on the Objects bar, and then double-click the Create Form By Using Wizard icon.

graphics/two_icon.jpg

Click the list arrow for choosing a table or query on which to base the form, and then click the name of the table or query you want.

graphics/three_icon.jpg

Specify the fields that you want included in the form by double-clicking the fields.

graphics/four_icon.jpg

Click Next to continue.

graphics/five_icon.jpg

Determine the arrangement and position of the information on the form (Columnar, Tabular, Datasheet, or Justified). Click Next to continue.

graphics/six_icon.jpg

Specify the style of the form, which affects its formatting and final appearance. In the preview area of the dialog box, you can see a preview of the selected style.

graphics/seven_icon.jpg

Click Next to continue.

graphics/eight_icon.jpg

Enter a name for your form.

graphics/nine_icon.jpg

Indicate whether you want to open the form or display it in Design view.

graphics/ten_icon.jpg

Click Finish.

graphics/14inf01.jpg

graphics/14inf02.jpg

graphics/14inf03.jpg

Create a Form Using the AutoForm Wizard

graphics/one_icon.jpg

In the Database window, click Forms on the Objects bar, and then click the New button.

graphics/two_icon.jpg

Click AutoForm: Columnar (to display records in a column), AutoForm: Tabular (to display records in rows), or AutoForm: Datasheet (to display records in Datasheet view).

graphics/three_icon.jpg

Click the list arrow, and then click the name of a table or query on which to base the form.

graphics/four_icon.jpg Click OK.

After a moment, Access creates a form and displays it in Form view.

graphics/14inf04.jpg

graphics/14inf05.jpg

Create a AutoForm

graphics/one_icon.jpg

In the Database window, click Tables or Queries on the Objects bar.

graphics/two_icon.jpg

Click the table in which you want to create an AutoForm.

graphics/three_icon.jpg

Click the New Object button list arrow on the Database toolbar.

graphics/four_icon.jpg

Click AutoForm.

graphics/14inf06.jpg

Did You Know?

You can save a new form . While the new form is displayed, click the Save button on the Form View toolbar. Type the name of your form in the Save As dialog box, and then click OK.



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

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