There are several table designs already set up in Access that you
can use in order to save time from the design process. Here is how
you can use them.
| 1) |
Open your database you worked on beforehand or
simply create a new database |
| 2) |
Select Tables, New |
| 3) |
Choose Table Wizard and click on OK |
| 4) |
Choose the table entitled "Contacts" |
| 5) |
Click on >> to select all the fields listed
in the wizard under this table. |
| 6) |
Click on Next |
| 7) |
Verify whether the table name provided by Access
is what you want to name your table to. |
| 8) |
Choose "No, I'll set the primary key"
when Access asks you whether you want to let the software add
a primary key to your table. |
| 9) |
Click on Next |
| 10) |
Select "ContactID" as the field holding
data that is unique to each field. |
| 11) |
Choose "Numbers I enter when I add new records".
Click on Next. |
| 12) |
When Access asks you whether you want to set
up relationships between the tables here just click on Next. |
| 13) |
Choose "Enter data directly into the table"
to be able to add records as soon as the design is done. |
| 14) |
Choose "Finish" |
| 15) |
Your new table will open in spreadsheet view
where you can add information right away. |
