Camashaly Design Has Decided to Add Some Additional Validation Rules

question 43

Short Answer

Camashaly Design has decided to add some additional validation rules to the Client table shown in Design view in the accompanying figure.They have asked you to create these validation rules.

Camashaly would like to make sure that if an employee enters the letters nc in the State field that it displays in the database as NC.What property do you need to change and what would you enter in the property box?

---

Definitions:

Addiction

A complex condition, a brain disorder characterized by compulsive engagement in rewarding stimuli, despite adverse consequences.

Drugs

Substances that cause changes in physiological or psychological functions when consumed, which can be used for medical purposes or illicitly.

Child Development

A multifaceted process where children progress through and achieve milestones in physical, cognitive, social, and emotional domains.

Physics

The natural science that studies matter, its motion, and behavior through space and time, and the related entities of energy and force.