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