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
|