In order to accomplish the task, you should perform one of the following tasks:
Write a macro.
Define a VBA (Visual Basic for Applications) code.
These tasks automate the import and export operations available on the External Data tab while working on Microsoft Office Access 2010.
Answer A is incorrect. You can use commands on the External Data tab to manually import and export data.
Answer B is incorrect. You cannot save the database as a spreadsheet file.

The Memo datatype stores alphanumeric values. These values can be numbers, alphabets, special characters such as <, >, ?, etc. This datatype is used in place of the Text datatype. It can store 65,535 characters. It also accepts text with rich text format, paragraphs, descriptions, etc.
Answer D is incorrect. The Attachment datatype is used to attach one or more files in a column. The files can be an office 2007 file, an image file, a text file, or a log file. Other types of files cannot be attached to the column. A file can be edited using software that is used for editing the file. If the datatype of a column is Attachment, the datatype for that column cannot be changed.
Answer C is incorrect. The Hyperlink datatype is used to store a hyperlink that is linked to a Web page or to a local or network file. It can store 1GB of data. Any type of file can be linked through this datatype. Each row of a table contains only one hyperlink.
Answer B is incorrect. The OLE Object datatype is used to attach files and add binary data to a table. This datatype stores each data in a bitmap format. This results in an increase in the size of a database file. Only a single file can be added to each row of a table. The files attached can be Microsoft Office files, graphics files, sound files, pdf files, etc.

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.

Explanation:

In order to accomplish the task, you should take the following steps:
Right-click on Form Header.
Choose the Ruler and Grid options.

After choosing both of these options, ruler and grid will be displayed on the form.
Answer D is incorrect. The Tools option is not used for displaying ruler and grid on the form.
Answer A is incorrect. Conditional Formatting does not include any option for ruler and grid.
Answer C is incorrect. When you right-click the form, it does not show the Format option.