In order to accomplish the task, you should use the Filter By Form feature. The Filter by Form feature is used to filter records based on the values in fields of a table, query, or form. It displays a filtering datasheet with blank fields. Each blank field is a combo box that contains a list of all the entries made in those fields. A user can select a value from this list or enter a new value. It is easy to use the Filter by Form feature when a table contains only a few fields.
Answer A is incorrect. The Filter by Selection feature is used to filter records based on the current selection in a field.
Answer C is incorrect. The Advanced Filter feature is used to create a simple query on a single table.
Answer B is incorrect. There is no such feature as Filter by Record in Access 2010.

When you export a table from Microsoft Office Access 2010 to Excel and the table contains a sub-datasheet, it exports only the main datasheet. To export the sub-datasheet, you should perform another export operation. In order to combine multiple Access objects into a single Excel workbook, you should export individual objects to different workbooks, and then merge all worksheets from within Excel.
Answer B is incorrect. Microsoft Office Access 2010 creates an RTF (Rich Text Format) document if you export information from Access to Word. This RTF document can be opened by Word and various other applications.
Answer C is incorrect. Microsoft Office Access 2010 converts a table into an HTML table if you export the table from Access to an HTML file.
Answer D is incorrect. Microsoft Office Access 2010 creates a copy of the table and stores the copy as a list if you export the table from Access to the SharePoint list.

The following datatypes cannot be filtered by using common filters:
OLE Object: 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.
Calculated Field: The Calculated Field datatype is used to store the results of a calculation. The calculation should refer to other fields created in the same table. In order to create the calculation, a user can use the Expression Builder that provides the use of IntelliSense and an easy way to access expression values.
Answer C and B are incorrect. These datatypes can be filtered by using common filters.
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.
The AutoNumber datatype is used for inserting a number automatically and incrementing it by one when a new record is inserted in a table. The increment can be changed through the New Values property. This property has the following two values:
Increment
Random

Explanation:
In order to display the Backstage view, you should click on the File tab in the upper-left corner of the program window. The Backstage view of MS Access 2010 is shown in the image given below: