Microsoft Exam 77-885 Topic 9 Question 5 Discussion

An input mask is used to control values of a field entered by a database user. The input mask includes literal characters, for example, space, dot, parenthesis, and placeholder. Microsoft Office Access contains a number of pre-defined input masks that match with most of the conditions. A user can create customized masks according to his needs. The Input Mask Wizard is used to create an input mask for text and date fields. If the user wants to create an input mask for numeric fields, he should enter the formatting symbol himself.

Answer A is incorrect. Validation text is used to provide an error if data has not been filled as per the Validation Rule.

Answer C is incorrect. In Microsoft Office Access 2010, an index is a list of field values included in a table. It helps Access in finding and sorting records quickly. An index stores the record's location based on the columns that are part of the index. The indexed fields have unique values which make it more efficient and faster for Access to read and find a specific field value.

Answer B is incorrect. Datatype defines the kind of data that a field can accept.