Bavant Publishing Has Decided to Add Some Additional Validation Rules

question 72

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.
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:

Trading Debt Securities

The act of buying and selling debt instruments, such as bonds or debentures, often for short-term profit.

Income Statement

A financial statement that reports a company's financial performance over a specific accounting period, detailing income and expenses.

Equity Method Investments

Accounting for investments where the investor has significant influence but not full control over the investee, recognizing their share of investee profits.

Cash Dividends

Distributions from a company to its shareholders, representing a share of the firm's profits.