Access Basics:
Table Wizard

Step-by-Step: Table Wizard

---

What you will learn:

to create a table using the wizard to add records to save the table

---

Start with: mytrips.mdb from previous lesson

Create a Table with the Table Wizard

The Trips table has a memo field TravelAgent for information about the travel agent. It would be useful to have that information in its own table. This will make it easier to store and update the contact information about each travel agent. If you use the same travel agent again, all the information will be there, waiting for you.

You will need fields for a mailing address, phone numbers, email address, as well as the parts of the agent's name.

1. If necessary, switch to the Database Window.
    
2. Click on Tables in the list of objects at the left.
    
3. In the right pane, click on the link Create table by using wizard. The Table Wizard opens to its first step.
    
4. If necesssary, select Business and then the Sample Table named Contacts.
   You will not need all of the fields from the sample table.
    
5. For the following fields in the Sample Fields list, click on the field's name and then click the > button to move it to the list of "Fields in my new table":
     ContactID
     FirstName
     LastName
     Address
     City
     StateOrProvince 
     PostalCode
     Region
     Country/Region
     CompanyName
     Title
     WorkPhone
     WorkExtension
     HomePhone
     MobilePhone
     FaxNumber
     EmailName
     Notes
    
6. Rename Field:
   Click on the field ContactID and then on the button RenameField...
    
7. Type AgentID as the new name and click on OK.
    
8. Click on Next to advance to the next step.
    
9. Enter the name Travel Agents for the table.
    
10. Select "Yes, set a primary key for me".
     
11. Click on the button Next.
    
    The next step in the wizard will let you create a relationship to an existing table. You will have to modify the Trips table before you can create a relationship. Right now you do not have a field that can be shared between the two tables.
     
12. Click on Next.
     
13. Select "Enter data into the table using a form the wizard creates for me." and click on Finish.
    The new AutoForm opens ready for you to enter data.
     
    Since World Travel Inc. is providing this database to clients, they want all of their agents to be in this table. (We won't take the time to add the full list!)
     
14. Enter the following records. Many fields will be blank for now.
    (Remember that these are not real people, the companies are not a real companies, and the email addresses are not real either!)
     

    FirstName	Jorge
    LastName	Martinez
    Country/Region	USA
    CompanyName	World Travel Inc.
    Title	Agent
    WorkPhone	615-555-1234
    EmailName	jmartinez@worldtravelinc.net

    
    Copy previous value: You can copy the value "World Travel Inc." into later records by using the key comb CTRL +  ' (the apostrophe) when your cursor is in the field CompanyName. This key combo copies into the current record the value of the field in the previous record.

    FirstName	Hector
    LastName	Chavez
    Country/Region	Argentina
    CompanyName	World Travel Inc,
    Title	Agent
    WorkPhone	555-9876
    EmailName	hchavez@worldtravelinc.net

    
    

    FirstName	Sheila
    LastName	Landers
    Country/Region	Australia
    CompanyName	World Travel Inc,
    Title	Branch Manager
    WorkPhone	5554-8890
    EmailName	slanders@worldtravelinc.net

    
    

    FirstName	William
    LastName	Gardner
    Country/Region	Argentina
    CompanyName	World Travel Inc,
    Title	Agent
    EmailName	bgardner@worldtravelinc.net
    WorkPhone	555-9876
    Notes	Nickname = Bill

    
     
15. Click on the Close button to close the form. A message box appears asking if you want to save changes to the design of the form.
     
16. Click on Yes. A small dialog window appears for you to enter a name for the form.
     
17. Accept the default name "Travel Agents" and click on OK. The form is saved and closed.