Creating Tables   «Prev  Next»

Creating a New Table with a Wizard - Exercise

Create a table using the Table Wizard

Objective: Create a table using the table wizard in Microsoft Access.

Exercise Scoring

This exercise is worth 5 points. It is auto-scored, which means you receive full credit by clicking Submit.

Instructions

  1. Open your Consulting database. If you do not have it from the previous module, download the course file Consulting_04.accdb from the resources page and open it in Microsoft Access.
  2. Use the wizard-style table creation feature (template/table wizard) to create a new table that can store the following client information:
    1. Customer ID (the wizard will create this as an auto-number primary key)
    2. Company (the business or organization the customer represents, e.g., "DistributedNetworks")
    3. First Name
    4. Last Name
    5. Address
    6. City
    7. State
    8. Zip

    Note: The State and Zip should be separate fields (not combined as "State/Zip").

    If the wizard creates different field names, rename fields so they match the list above (or are very close and clearly understood).

  3. Name the table Clients and allow Access to create a primary key for you.
    Tip: after the table is created, open it in Design View and confirm that fields have appropriate datatypes.

When you are finished, you may paste brief notes in the text box below (optional), then click Submit to view the Results page.