Primary Key
Primary Key tblCustomer_Prospect | Cust_ID | Last Name | First Name | Street | City | State | Zip | Telephone | Made_Purchase | Touchpoint | 1 | Flynn | Colleen | 44 Hastings Ave. | Portland | OR | 97223-0974 | 503-665-5594 | Yes | Web | 2 | Bauer | Richard | 322 Scenic Drive | Portland | OR | 97253-9944 | 503-297-4493 | No | Ad | 3 | DelFino | Joseph | 119 Young Ave. | Portland | OR | 97202-4432 | 503-668-5503 | Yes | Mouth | 4 | Hardman | Pauline | 57 Beekman Road | Portland | OR | 97269-0055 | 503-789-9143 | | | 5 | Yang | Walter | 83 Hunter's Trail | Portland | OR | 97299-9453 | 503-789-1742 | | | 6 | Kozlowski | Peter | 92 Mountain Road | Portland | OR | 97266-0482 | 503-297-5780 | | | 7 | Rodriguez | Elena | 751 Lounsbury Ave. | Portland | OR | 97228-0516 | 503-297-7921 | | | 8 | Stillman | Charles | 82 County Road | Portland | OR | 97269-5043 | 503-789-4032 | | | 9 | Nagel | Ellen | 901 Forest Road | Portland | OR | 97253-9540 | 503-297-5021 | | | 10 | Sheridan | Amy | 29 Glen Ridge | Portland | OR | 97299-5903 | 503-789-4920 | | | 11 | Venable | Stephen | 653 Ridge Road | Portland | OR | 97223-4921 | 503-665-2943 | | | 12 | Spadafino | Anthony | 43 8th Ave. | Portland | OR | 97202-4320 | 503-668-2399 | | | 13 | Ng | Victor | 72 Lincoln Pl. | Portland | OR | 97266-2039 | 503-297-5927 | | | 14 | Nielsen | Elizabeth | 67 Forest Trail | Portland | OR | 97228-8522 | 503-297-7020 | | | 15 | Downey | Joseph | 12 Monica Court | Portland | OR | 97255-6902 | 503-668-3901 | | | 16 | St. John | Bettye | 893 Pleasant Ave. | Portland | OR | 97250-5030 | 503-665-2935 | | | 17 | Keating | Christopher | 95 Roundhill Road | Portland | OR | 97223-4939 | 503-665-1194 | | | 18 | Melman | Jonathan | 42 College Dr. | Portland | OR | 97228-3094 | 503-297-8925 | | | 19 | Grote | Teresa | 69 Rocky Hill | Portland | OR | 97202-5926 | 503-668-3049 | | | 20 | Tripper | Benjamin | 723 Pine St. | Portland | OR | 97223-9504 | 503-665-4929 | | |
1) Data type for each field is Text except “Made_Purchase” field. 2) “Made_Purchase” field is of type “Yes/No”. In the data sheet view, you will see a check box which you need to check if you wish to indicate “Yes” or leave it blank if you wish to indicate “No”. 3) Only partial data is entered here. Please complete the table by inserting values for the fields “Made_Purchase” and “Touchpoint”. Touchpoint field takes one of the three values: Web, Ad or Mouth. 4) After this, please make sure you follow the directions given in the case description and complete the case. 