Microsoft Exam 77-885 Topic 7 Question 21 Discussion

In order to accomplish the task, you should use the validation rule property. A validation rule is a set of rules associated with a column so that a user is restricted from entering invalid data. A user can be restricted from entering data through the following options:

Datatypes: When a field is assigned to a datatype, data of another type cannot be inserted in the field.

Field size: The field size restricts the amount of data to be inserted in a table.

Table Properties: Certain table properties such as Required forces a user to enter data or the Format property forces a user to enter data in a defined format.

A validation rule can be applied by using the Validation Rule property. A user can be intimated about the invalid data through the Validation Text

property.

Answer B is incorrect. The value of the Caption property is displayed as text on a Label control in a Form.

Answer A is incorrect. The Input Mask property is used to change the format of a field having the Text or Date/Time datatype. This property provides the formats for different types of data such as zip-code, phone, date, time, password etc. When the Input Mask property is set for a field, a user should fill the data in the same format. Any other format is either converted to the given format or remains as it is.

Answer C is incorrect. The IME Mode property is related to East Asian languages.