PrepAway - Latest Free Exam Questions & Answers

Which of the following is located along the left side of the Access screen and provides an interface for all d

Which of the following is located along the left side of the Access screen and provides an interface
for all database objects?

PrepAway - Latest Free Exam Questions & Answers

A.
Navigation Pane

B.
Quick Access Toolbar

C.
Object Dependencies pane

D.
Application part

Explanation:
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.


Leave a Reply