Which of the following objects will you use to accomplish the task?

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a
database named Database1 using Microsoft Access 2010. The database includes four database
objects. You want to show and hide categories regardless of the settings in the Navigation Options
dialog box. Which of the following objects will you use to accomplish the task?

A.
Module

B.
Form

C.
Query

D.
Macro

Explanation:
In order to accomplish the task, you should use a macro. 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 A is incorrect. In Microsoft Office Access 2010, a module is a database object that includes
custom procedures coded using Visual Basic. It provides a more discrete flow of actions and way to

trap errors. A macro includes functions that can be called from anywhere in the Access application. It
is directly linked with a form or a report as a result of events.
Answer C is incorrect. In Microsoft Office Access 2010, a query is a database object that presents a
custom view of data from one or more than one table. A query is used to select, update, insert, and
delete data. It is also used to create a new table using data from existing tables. A user can create a
query by using the graphical query or writing SOL statements.
Answer B is incorrect. In Microsoft Office Access 2010, a form is a database object that is mainly
used for data input. It controls the execution of an application. A form can also customize the
presentation of data extracted from queries or tables. A user can take a print of forms. Forms are
designed to run a macro or a Microsoft Visual Basic procedure as a result of various events.