The following should be included in the Customer table:
a. Customer Num – can only accept numbers although the field has been defined as
text
b. The Customer table should include state and country for only those listed in the
Figure 1- 2
c. Phone – can only accept numbers with 000-000-0000 format
d. First Contact – will not allow entering a date later than the current date. Create a
suitable message in Validation Text for this field