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 ...

Get Microsoft® Office Access 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.