Case 3-1 Bavant Publishing Has Decided to Add Some Additional Validation Rules

question 7

Essay

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?

---

Definitions:

Repair People

Individuals or workers specialized in fixing and maintaining machinery, equipment, or facilities.

Marginal Revenue Product

The additional revenue generated from using one more unit of a factor of production or input.

Mechanics

The branch of physics that deals with the behavior of physical bodies when subjected to forces or displacements and the subsequent effects of the bodies on their environment.

Profit

The financial gain made in a transaction or through business operations after subtracting all expenses.