Microsoft Exam 77-885 Topic 6 Question 10 Discussion

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.