You have a database named Database1 created in Microsoft Office Access 2010. This database
contains several Access objects, such as form, table, query, and report. You want to create a report
that contains full information about all objects of Database1. Which of the following tools will you
use to accomplish the task?
A.
Performance Analyzer
B.
Office Diagnostics
C.
Compact and Repair Database
D.
Database Documenter
Explanation:
Database Documenter is an Access tool that is used to create a report that contains full information
for all selected objects. After creating the report, Database Documenter opens it in Print Preview.
This report contains information about object properties, control properties, code modules, and user
permissions.
Answer A is incorrect. The Performance Analyzer utility is used to analyze the performance of the
Microsoft Office Access objects such as tables, forms, macros, modules, reports, and queries in the
database. This utility has three types of analysis results: ideas, suggestions, and recommendations.
The user can instruct Access to optimize the database file by following through on any of the
suggestions and recommendations.
Answer C is incorrect. The Compact and Repair Database is a command used in Microsoft Office
Access 2010. It rearranges data, fills up the
spaces left behind by the deleted objects, and repairs the problems. It compresses the database if
any problem is encountered in the Access database.Answer B is incorrect. The Microsoft Office Diagnostics utility has a series of diagnostic tests that
helps a user to discover why the Microsoft Office programs are not working properly. The diagnostic
tests provide the information about the problems, and ways to solve these problems. When
Microsoft Office Diagnostics determines that data might help diagnose and fix a problem, the system
asks the user whether he wants to tell the problem to the Microsoft. After completing all the tests,
the user prompts to visit a Web page in order to get advice based the results of the tests.