1. In the Database window (Database window: The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click Forms under Objects.
2. Click the New button on the Database window toolbar.
3. 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.
   • AutoForm: PivotTable   The form opens in PivotTable view. You can add fields by dragging them from the field list to the different areas in the view.
   • AutoForm: PivotChart   The form opens in PivotChart view. You can add fields by dragging them from the field list to the different areas in the view.

   If the wizard doesn't start

4. Click the table or query that includes the data you want to base your form on.
5. Click OK.

Microsoft Access applies the last autoformat (autoformat: A collection of formats that determines the appearance of the controls and sections in a form or report.) you used to the form. If you haven't created a form with a wizard before or haven't used the AutoFormat command on the Format menu, it uses the Standard autoformat.

1. In the Database window (Database window: The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click Forms under Objects.
2. Click the New button on the Database window toolbar.
3. 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.

   If the wizard doesn't start

4. Click the name of the table or other record source that includes the data you want to base your form on.

    Note   You don't need to do this step if you selected Form Wizard or PivotTable Wizard in step 3 — you can specify the record source for the form later.

5. Click OK.
6. Follow the instructions in the wizard.

   If the resulting form doesn't look the way you want, you can change it in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.), PivotTable view, or PivotChart view.

  Notes  

• If you want to include fields from multiple tables and queries in your form, don't click Next or Finish after selecting the fields from the first table or query in the Form Wizard. Repeat the steps to select a table or query, and pick fields that you want to include in the form, until you have selected all the required fields.

• If you click one of the AutoForm options, Microsoft Access uses the autoformat (autoformat: A collection of formats that determines the appearance of the controls and sections in a form or report.) you last specified, either in the Form Wizard or using the AutoFormat command on the Format menu in Design view.

1. In the Database window (Database window: The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click Forms under Objects.
2. Click the New button on the Database window toolbar.
3. In the New Form dialog box, click Design View.
4. Click the name of the table or other record source (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.) that includes the data you want to base your form on. If the form won't contain data (for example, if you want to create a form to use as a switchboard to open other forms or reports, or if you want to create a custom dialog box), don't select anything from this list.

   Tip

   If you want to create a form that uses data from more than one table, base your form on a query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.).

5. Click OK.

Microsoft Access displays the form in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).