Microsoft Office 2000

Lesson 7: Access 2000 (Part 2)

Creating Forms

You can create a form for your database that makes data entry much easier and more convenient. You can create forms automatically with the Wizard or AutoForm.

Create a form using the Wizard

• In the Database Window under Objects click on Forms
• Click the New button on the Database window toolbar

• In the New Form dialog box, click the wizard that you want to use. A description of the wizard appears in the left side of the dialog box. Options include Design View (create a form without using a wizard), Form Wizard, AutoForm Columnar, AutoForm Tabular, AutoForm Datasheet, Chart Wizard and PivotTable Wizard.

• In the Choose the table or query where the object’s data comes from dropdown box, click the name of the table or other record source you wish to use. You can skip this step if you select the Form Wizard option as you can specify the record source for the form in the wizard.

• Click OK

• If you choose Form Wizard, Chart Wizard, or PivotTable Wizard above, follow the directions in the wizard dialog boxes. If you choose AutoForm: Columnar, AutoForm: Tabular, or AutoForm: Datasheet, Microsoft Access automatically creates your form.

If the resulting form doesn't look the way you want, you can change it in Design view.

Creating a form using AutoForm
AutoForm creates a form that displays all fields and records in the underlying table or query. If the record source you select has related tables or queries, the form will also include all the fields and records from those record sources.

• In the Database Window under Objects click on Forms
• Click the New button on the Database window toolbar
• In the New Form dialog box, click one of the following wizards:
  • AutoForm: Columnar - Each field appears on a separate line with a label to its left.
  • AutoForm: Tabular - The fields in each record appear on one line, with the labels displayed once at the top of the form.
  • AutoForm: Datasheet - The fields in each record appear in row-and-column format, with one record in each row and one field in each column. The field names appear at the top of each column.
• Click the table or query that contains the data you want to use
• Click OK

Using the Wizard or AutoForm can really streamline the process of creating forms. For additional information on creating forms and for instructions on creating forms manually in Design View see Creating a Form in Microsoft Office 2000 for Windows: Visual QuickStart Guide pp. 323-339.

Print this page

  1  2  3  4