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.

module

In order to accomplish the task, you should choose the All Access Objects options in the Navigation Pane. It displays all Access objects included in Database3 as shown in the image given below:

Explanation:

When you click this button, you can show or hide the column totals in the query results.

1 - Open Microsoft Office Access 2010.
2 - Click the File tab.
3 - Click the New button.
4 - Click a template category.
5 - Choose the template.
6 - Type a name for the database.
7 - Click the Download button.
Explanation:
1.Open Microsoft Office Access 2010.

2.Click the File tab and then click the New button.

3.Click a template category.

4.Choose the template.

5.Type a name for the database and then click the Download button.