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.

In order to save the entire form as the report, you should open the form in the Design view and then click the Save As button.

Choose the Save As Report option.

The form header and footer are used as the report header and footer after saving the form as the report.
Answer B is incorrect. If you click Report Wizard, a new report is created based on the form.
Answer D is incorrect. You are not required to delete the form header and footer to save the form as the report.
Answer C is incorrect. Access allows you to save the form as the report.

The features of a primary key are as follows:
It uniquely identifies each record.
It cannot be null.
It should exist when the record is created.
Its value should remain stable once it is established.
It should be simple and contain as few attributes as possible.

1 - Adjust the size of sections of design grid.
2 - Apply a new theme to the form.
3 - Modify the control's size.
4 - Organize controls logically for assisting data entry.
5 - Change the form elements' properties in the Property Sheet
6 - Add fields from the Field List.
7 - Add controls for limiting data entry selections.
Explanation:
Adjust the size of sections of design grid.
Apply a new theme to the form.
Modify the control's size.
Organize controls logically for assisting data entry.
Change the form elements' properties in the Property Sheet.
Add fields from the Field List.
Add controls for limiting data entry selections.

In order to accomplish the task, you will have to perform one of the following tasks:
Select the column and click on the Ascending button.

Right-click on the column header and choose the Sort Smallest to Largest option.

Both these tasks will display the incomplete or missing records on the top of the column as shown in the image given below:

Answer A is incorrect. When you perform this, you get the incomplete or missing records on the bottom of the column.
Answer D is incorrect. The Toggle Filter option is used for filtering the data of a table.