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…

Question

Options

• AModule
• BForm
• CQuery
• DMacro

• A
  8% (2)
• B
  4% (1)
• C
  12% (3)
• D
  76% (19)

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

No community discussion yet for this question.