Bavant Publishing Has Decided to Add Some Additional Validation Rules

question 93

Short Answer

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.
Because many of the customers that Bavant Publishing services are located in Pennsylvania, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?

---

Definitions:

Four-Figure Accuracy

A term used to describe a level of precision in numerical calculations or measurements that ensures accuracy to the nearest thousand.

Four-Figure Accuracy

A precision level that indicates numerical values are accurate to within plus or minus one out of ten thousand.

Five-Figure Accuracy

Describes numerical values precise to five digits.

Repeating Decimal

A fraction represented in decimal form where a specific set of digits continues to repeat endlessly.