Camashaly Design Has Decided to Add Some Additional Validation Rules

Short Answer

Camashaly Design has decided to add some additional validation rules to the Client table shown in Design view in the accompanying figure.They have asked you to create these validation rules.

Camashaly would like to make sure that if an employee enters the letters nc in the State field that it displays in the database as NC.What property do you need to change and what would you enter in the property box?