What happened to the Table Wizard?

Symptoms

In earlier versions of Access, you used the Table Wizard to quickly create a table from sample tables and fields. But in Microsoft Office Access 2007, there is no Table Wizard.

Cause

The Table Wizard has been removed from the current version of Access.

Resolution

To quickly create a table in Access 2007, you use table templates and field templates. A table template is an empty table that you can start using as-is, or modify to suit your needs. Access 2007 includes the following table templates, designed to be compatible with the Windows SharePoint Services 3.0 lists of the same name:

  • Contacts    A table that is used for managing business contact information, which includes e-mail addresses, Web page URLs, and attachments, such as a service contract and a photo.
  • Tasks    A table that is used for tracking tasks, which includes a field for attachments.
  • Issues    A table that is used for tracking issues, which includes a field for attachments and an append-only Memo field that keeps a history of old field values.
  • Events    A table that is used for managing events, which includes a rich text Memo field and a field for attachments.
  • Assets    A table that is used for managing business assets, which includes two currency fields for tracking asset depreciation.

After you create a table by using a table template, you may want to add fields by using field templates. A field template is a predefined field that you can add to any table in Datasheet view.

Create a new table by using a table template

  1. Click the Microsoft Office Button Button image, and then click Open.
  1. In the Open dialog box, select and open the database in which you want to create a table.
  2. On the Create tab, in the Tables group, click Table Templates and then select one of the available templates from the list.

Access Ribbon Image

A new table is inserted into your database, based on the table template that you chose.

Add a field by using a field template

You use the Field Templates task pane to choose from a list of field templates. The field template definition includes a field name, a data type, a setting for the field's Format property, and other field properties.

  1. On the Home tab, in the Views group, click View, and then click Datasheet View.
  2. On the Datasheet tab, in the Fields & Columns group, click New Field.

Access Ribbon Image

  1. Select one or more fields in the Field Templates pane, and then drag the fields that you selected to the table where you want to insert the new column.
 
 
Applies to:
Access 2007