Which of the following is used to control values of a field entered by a database user?

Which of the following is used to control values of a field entered by a database user?

A.
Validation text

B.
Datatype

C.
Index

D.
Input mask

Explanation:
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.