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?
A.
Compact and Repair Database
B.
Database Documenter
C.
Back Up Database
D.
Linked Table Manager
Explanation:
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.