Question: 12. View the tblClient table in Design View, and then define a field validation rule for the Gender field in the tblClient table. Acceptable

12. View the tblClient table in Design View, and then define a

12. View the tblClient table in Design View, and then define a field validation rule for the Gender field in the tblClient table. Acceptable field values for the Gender field are F and M (in that order). Use the message Must be F or M to notify a user who enters an invalid Gender field value. Save the table, clicking Yes when warned about data integrity rules. Switch to Datasheet View and test the field validation rule for the Gender field, making sure any tested field values are the same as they were before your test. (Hint: You can confirm this by retyping the correct value or by pressing the Esc key.) Close the table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!