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 . Report
C . Form
D . Macro

View Answer

Answer: C

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 option 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 option 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 option B 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.

Reference: http://office.microsoft.com/en-us/access

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Form Design