Which of the following restricts a user from entering invalid data in the table columns?
A.
Input mask
B.
Application part
C.
Index
D.
Validation rule
Explanation:
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 A is incorrect. 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 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. An application part is a template available in Microsoft Office Access 2010. It
can be added to an existing database. It is used to extend the functionality of an Access database. It
can include only a single table or a number of database objects, such as tables, forms, reports, and
even relationships. A user can open up the Application Parts gallery in order to view the built-in parts.