Critical Thinking Questions Case 3-1 Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying 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

Critical Thinking Questions Case 3-1 Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying 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 Critical Thinking Questions Case 3-1 Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying 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?

Critical Thinking Questions Case 3-1 Bavant Publishing Has Decided to Add