The Yes/No datatype is a Boolean datatype that is used to specify whether a condition is true or false. A record can be retrieved based on any given condition. A user can use the WHERE clause to retrieve the data for those records that have been set to yes or no.
Answer A 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.
Answer B is incorrect. 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 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

Take the following steps to change the default database location:
1.Click the File tab to open the File gallery.

2.Click the Options button to open the Access Options dialog box.

3.Type or browse to the path to the new default database location on the Default Database Folder text box of default General page.

Answer A and C are incorrect. By following these steps, you can simply save your database and project on the desired location, but these steps will not help in setting the location as a default database location. You have to manually choose the location every time you are going to save a new database or project.
Answer D is incorrect. By following these steps, you can create a new database in Microsoft Access 2010.

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
Answer B is incorrect. 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 A 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.
Answer D is incorrect. The Yes/No datatype is a Boolean datatype that is used to specify whether a condition is true or false. A record can be retrieved based on any given condition. A user can use the WHERE clause to retrieve the data for those records that have been set to yes or no.

The navigation form is a specialized form that is intended to provide user navigation through an application. It has many navigation controls.
Answer B is incorrect. Form Wizard is used to build a form using the wizard.
Answer A is incorrect. The blank form is used to instantly create a new blank form without any control.
Answer C is incorrect. Form design is used to create a new blank form and display it in the Design view.

The Quick Access Toolbar in MS Access 2010 is a customizable toolbar which is displayed in the title bar of the Database window. It has a set of commands or functions (save, undo/redo, and print) that are independent of the tab on the ribbon currently displayed in MS Access. The Quick Access Toolbar can be moved from one of the two possible locations. A user can add any Access command as a button to the Quick Access Toolbar.
Answer A is incorrect. The Navigation Pane provides an interface for all database objects, such as tables, queries, forms, reports, macros, and modules. It is located along the left side of the Access screen. In the Navigation Pane, all items are organized into groups. It is also used to show or hide the database objects.
Answer D is incorrect. In Microsoft Office Access 2010, a macro is a database object that defines the actions that are required for Access to perform as a result of a defined event. It is also used to open and execute queries, open tables, and print or view reports. A user can add simple conditions in macros to specify when actions are performed or skipped.
Answer B 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.