You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer has a database named Sales
created in Microsoft Office Access 2010. The database contains detailed information about
thousands of orders. You want to summarize these orders to illustrate the rate of growth of the
company’s sales. Which of the following database objects will you generate to accomplish the task?
A.
Macro
B.
Report
C.
Query
D.
Module
Explanation:
To summarize the orders, you should create a report in Microsoft Office Access 2010.
In Microsoft Office Access 2010, a report is a database object that is used to display information in a
well formatted way. The report is displayed on screen or on paper. It cannot be used to enter or edit
information. A user can view reports in the Report, Design, Print, and Layout views.
Answer A 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 openand 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 D 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.