Free Preparation Discussions
MENU
Microsoft Exam 77-885 Topic 6 Question 38 Discussion
Topic #: 6
You work as a Database Designer for Tech Perfect Inc. The company has a Windows based environment. A database file created in Microsoft Office Access 2010 is shared over the network and multiple users work directly with the file simultaneously. The database file has a small risk of becoming corrupted. The risk of corruption is greater if users often modify data in Memo fields, and the risk grows over time. Which of the following will you use to mitigate this risk?
In order to mitigate the risk, you should use the Compact and Repair Database. 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 C is incorrect. The Back Up Database is used to save the database file to a removable disk or network drive to ensure that it is safe from problems.
Answer D is incorrect. The Linked Table Manager is used to list the paths to all currently linked tables.
Answer B is incorrect. The Database Documenter is used to create a report containing all information about each selected Microsoft Access.
Currently there are no comments in this discussion, be the first to comment!