PrepAway - Latest Free Exam Questions & Answers

Where can a user add any Access command as a button in Microsoft Access 2010?

Where can a user add any Access command as a button in Microsoft Access 2010?

PrepAway - Latest Free Exam Questions & Answers

A.
Navigation Pane

B.
Index

C.
Quick Access Toolbar

D.
Macro

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

2 Comments on “Where can a user add any Access command as a button in Microsoft Access 2010?

  1. jean says:

    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.




    0



    0

Leave a Reply