The main sections of the design grid are as follows:
Detail: By default, this section is present on the report. The Detail section consists of the main body of the report.
Page Header: By default, this section is present on the report. The Page Header section includes information displayed at the top of each page of the report.
Page Footer: By default, this section is present on the report. The Page Footer section includes information displayed at the bottom of each page of the report.
Report Header: This section includes information displayed at the top of the first page of the report.
Report Footer: This section includes information displayed at the bottom of the last page of the report.

In order to accomplish the task, you should use the validation rule property. 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 B is incorrect. The value of the Caption property is displayed as text on a Label control in a Form.
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 C is incorrect. The IME Mode property is related to East Asian languages.

1 - Put the insertion point in the Field row.
2 - Click the Builder button.
3 - Double-click the field to be used in the calculation.
4 - Build an expression using the operator buttons and element
5 - Type other values required to be included in the expression
6 - Click the OK button.
7 - Click the Run button.
Explanation:
Take the following steps to create a calculated field:
1.Put the insertion point in the Field row of a blank column in the Design grid.

2.Click the Builder button.

3.Double-click the field to be used in the calculation.
4.Build an expression using the operator buttons and elements area.
5.Type other values required to be included in the expression.
6.Click the OK button.

7.Click the Run button.

Explanation:
In order to accomplish the task, you should choose the Cascade Update Related Fields option. When you choose this option, the changes made to the primary field of the StudentCourses table will be automatically copied to the related field of the Students table.

The program window opens in the Backstage view when a user starts Microsoft Office Access 2010 without opening a database. The Backstage view is a full-screen user interface model in which commands related to managing MS Access and Access database are arranged in the form of buttons and pages. The File tab in the upper-left corner of the program window displays the Backstage view. The Backstage view allows a user to create, save, and check hidden metadata or personal information. It also helps in discovering and using the features that are not related to the authoring features on the Ribbon.
Answer D is incorrect. The PivotChart view of a table can be used to display the data of a table in the desired format using a graph. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotChart view is opened, a blank work area is displayed and the columns of the table are displayed in the Chart Field List window. A user has to drag and drop the fields to view the desired result. The PivotChart view uses an Office Chart Component and helps a user to create dynamic and interactive charts.

Answer B is incorrect. The PivotTable view of a table can be used to display the data of a table in the desired format. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotTable view is opened, a blank work area is displayed and the columns of the table are displayed in the Pivot Table Field List window. A user has to drag and drop the fields to view the desired result.

Answer C is incorrect. The Design view of a table displays its fields and datatypes. New fields can be added to the table and assigned to a datatype. A user cannot insert data in this view. The datatype of a field can be formatted and other table properties such as field size, validation rule, etc., can be set for the field.