Customer Table

 Structure of the Customer table

Field Name

Data Type

Field Size

Primary Key?

Description

Customer ID

Text

3

Yes

Customer number (primary key)

Customer Name

Text

20

 

Customer/Dealer name

Contact Person

Text

20

 

Contact person

Phone

Text

8

 

Contact phone number

Table 3

 Data for the Customer table

Customer ID

Customer_Name

Contact Person

Phone

COM

Complete Auto Sales

Your Name

455-3451

SPO

Sports Car Emporium

Mario Smellhouse

455-6639

PET

Pettys Antiques

Bonnie York

456-7877

TRA

Travel All Auto

Kari Thompson

415-2258

MEL

Mels Classic Car Lot

Mel Radbell

785-9111

OTT

Ottos Old Autos

Otto Foreman

555-8890

Table 4

 

lmayer@elgin.edu