Microsoft® Office Access 2003 Inside Out

Creating Additional Tables in Contact Tracking

So far, we’ve discussed how to build the Companies table in an Access project. Before you can define constraints and relationships, you’ll need to build several more tables. Let’s start by building the Contacts table and the CompanyContacts table. Table 17-4 shows you the columns you need for the Contacts table.

Table 17-4. Column Definitions for the Contacts Table

Column Name	Data Type	Length	Allow Nulls	Description
ContactID	int	4	No	Unique contact ID
LastName	nvarchar	50	No	Last name
FirstName	nvarchar	50	Yes	First name
MiddleInit	nvarchar	1	Yes	Middle initial
Title	nvarchar	10	Yes	Person title
Suffix	nvarchar	10	Yes	Person suffix (Jr., Sr., II, etc.)
ContactType	nvarchar	50	Yes	Description of the contact type
BirthDate	datetime	8	Yes	Birth ...