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…

Question

Options

• AMacro
• BReport
• CQuery
• DModule

• A
  13% (3)
• B
  74% (17)
• C
  4% (1)
• D
  9% (2)

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

No community discussion yet for this question.