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

You want to customize the presentation of data extracted from queries or tables that are created in
Microsoft Office Access 2010. Which of the following database objects will you use to accomplish the task?

A.
Module

B.
Macro

C.
Form

D.
Report

Explanation:
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.
Answer B 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 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 D is incorrect. Report is used to display information from tables in a nicely formatted and
easily accessible way. Information can be displayed on the computer screen or on paper. A report
can contain information from multiple tables and queries, values calculated from information in the
database, and formatting elements such as headers, footers, titles, and headings.