ACC2000: Optional Fields Not Added to Database Made by Database Wizard

Novice: Requires knowledge of the user interface on single-user computers.

When you use the Database Wizard to create a database, optional fields are not added to the database. You must manually select optional fields before the wizard includes them.

If you decide that you want to add optional fields to the forms that are created with the wizard, you must add the fields to the existing table and then drag the fields from the field list to display them on your existing form. The following steps demonstrate how to add the Children Names field from the Address template to the database created by the wizard.

1. Start Microsoft Access, and on the File menu, click New Database.
2. In the New dialog box, click the Databases tab, click the Expenses database, and then click OK.
3. In the File New Database dialog box, click Create to create a new database with the default file name.
4. On the first screen of the Database wizard, click Next.
5. On the second screen, note that in the Fields in the Table list box, the Email Name field is not selected.
6. Click Finish to accept the default database settings. When the new database is created, press F11 to bring up the Database window.
7. Open the Employees table in Design view. Add a new field with the following properties to the table:

      Table: Addresses
      --------------------------
      Field Name: Email Name
         Data Type: Text
         Indexed: No
   						

   NOTE: If you want to add the additional field between a particular row, select the row, and then on the Insert menu, click Rows.
8. After adding the Email Name field, close the table.
9. Open the Expense Report by Employee form in Design view. If the field list is not displayed, on the View menu, click Field List. Drag the Email Name field from the field list to the location where you want it on the form.
10. Open the form in Form view. Note that the optional field now appears on the form.

Steps to Reproduce Behavior

1. Repeat steps 1 through 5 in the "Resolution" section earlier in this article.
2. Click Finish to accept the default database settings. When the new database is created, press the F11 key to bring up the Database window.
3. Open the form in Design view.
   
   Note that none of the optional fields appear on the form.

For more information about creating databases, click Microsoft Access Help on the Help menu, type Create a database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.