Microsoft Exam 77-885 Topic 7 Question 33 Discussion

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.