Access Basics:
Table Wizard
|
Access Basics:
|
|
|
|
||
|
Before you can create relationships between tables, you need to have another table! You already created a table manually so this time you will use a wizard. Access provides a Table Wizard to walk you through some choices to create one of the sample tables, like lists of addresses and phone numbers, students and their classes, orders, products, invoices, reservations, or tasks. Rarely will the sample table be exactly what you want! It can still be helpful to choose the fields that most closely match what you do want. You can always make changes in Design View afterwards. The table wizard offers a list of sample tables in two categories: Business and Personal. The example dialog below walks you through the choices to create a table of Suppliers for the items in the collection of Star Wars items.
In step 3 you could choose to create a relationship to an existing table. However, the shared field must already exist in the table that you choose. The SuppliersID field would be the choice for this example. |
|
Project 2: Access Basics
|
Start with: mytrips.mdb from previous lesson Create a Table with the Table WizardThe 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 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~ |
Click to
see the wizard steps:
In
the right pane, click on the link 
If
necesssary, select Business and then the Sample Table
named Contacts.
to move it to
the list of "Fields in my new table":
Rename
Field: 
Enter
the name 
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.
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.
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 
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.
