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:

Social Security Tax

Mandatory contributions collected from employees and employers to fund the Social Security program, providing benefits for retirees, the disabled, and survivors.

Medicare Tax

A federal tax deducted from employees' paychecks to fund the Medicare program, which provides health insurance for individuals aged 65 and over.

Social Security Tax

A tax levied on both employers and employees to fund the Social Security program, which provides benefits for retirees, disabled persons, and survivors.

Medicare Tax

A federal tax deducted from an employee's paycheck to fund the Medicare program.