Essay
Case 3-1
PrattLast Associates has decided to add some additional validation rules to the Account table. They have asked you to create these validation rules.
-PrattLast would like to make sure that if a manager 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?
Correct Answer:

Verified
You need to change the Format ...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q17: A default value is a value that
Q61: Filter By Query allows you to filter
Q62: A(n)_ field is a field that can
Q64: To order the records in the Account
Q65: To include totals and other statistics at
Q65: To create a multivalued field,create a(n)_ field
Q67: When a filter is in effect, you
Q70: In the PrattLast Associates database, a one-to-many
Q82: The button on the Access status bar
Q83: Validation rules can indicate a _.<br>A) required