what appears in the default label attached to a control created by dragging the field from the field list onto a form or report?

Which Access property is used to determine what appears in the default label attached to a control
created by dragging the field from the field list onto a form or report?

A.
Input mask

B.
Caption

C.
Validation rule

D.
Index

Explanation:
The Caption property is used to determine what appears in the default label attached to a control
created by dragging the field from the field list onto a form or report. The caption also appears as
the column heading in the Datasheet view that contains the field. It can be as long as 2,048
characters.
Answer C is incorrect. 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. 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 D 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.