Monday, July 28, 2014

How To Creating a Form Using AutoForm in Access 2003

graphics/microsoft160_1.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 Form Using the AutoForm Wizard

graphics/1_icon.jpg
In the Database window, click Forms on the Objects bar, and then click the New button.
graphics/2_icon.jpg
Click the AutoForm you want to create.
  • AutoForm: Columnar to display records in a column.
  • AutoForm: Tabular to display records in rows.
  • AutoForm: Datasheet to display records in Datasheet view.
  • AutoForm: PivotTable to display records in a PivotTable.
  • AutoForm: PivotChart to display records in a PivotChart.
graphics/3_icon.jpg
Click the list arrow, and then click the name of a table or query on which to base the form.
graphics/4_icon.jpg Click OK.
After a moment, Access creates a form and displays it in Form view.
graphics/07inf02.jpg

Save a New Form

graphics/1_icon.jpg
Display the new form in Form view, and then click the Save button on the Form View toolbar.
graphics/2_icon.jpg
Type the name of your form.
graphics/3_icon.jpg
Click OK.
graphics/07inf03.jpg

Create an AutoForm

graphics/1_icon.jpg
In the Database window, click Tables or Queries on the Objects bar.
graphics/2_icon.jpg
Click the table or query in which you want to create an AutoForm.
graphics/3_icon.jpg
Click the New Object button list arrow on the Database toolbar.
graphics/4_icon.jpg
Click AutoForm.
graphics/07inf04.jpg