Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the acsampanying figure. They have asked you to create these validation rules.
Bavant would like to make sure that if an employee enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?

Question

Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the acsampanying figure. They have asked you to create these validation rules. 
  Bavant would like to make sure that if an employee enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?

Quizplus · Accepted Answer

The Answer of Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the acsampanying figure. They have asked you to create these validation rules. 
  Bavant would like to make sure that if an employee enters the letters pa in the State field that it displays in the database as PA. What property do you need to change and what would you enter in the property box?

Bavant Publishing Has Decided to Add Some Additional Validation Rules