Microsoft Exam 77-885 Topic 1 Question 3 Discussion

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 B is incorrect. 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 C is incorrect. The Object Dependencies pane is available on the Relationships group in the Database Tools tab. It demonstrates the interactions or dependencies of all database objects. It helps in preventing record sources from being accidentally deleted. It also displays how other objects are affected by the design change whenever any change is made in the design of an object.

Answer D 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.