nerdexam
Microsoft

77-885 · Question #18

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…

The correct answer is A. Compact and Repair Database. 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…

Managing the Access Environment

Question

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?

Options

  • ACompact and Repair Database
  • BDatabase Documenter
  • CBack Up Database
  • DLinked Table Manager

How the community answered

(32 responses)
  • A
    75% (24)
  • B
    6% (2)
  • C
    3% (1)
  • D
    16% (5)

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 Answer: B is incorrect. The Database Documenter is used to create a report containing all information about each selected Microsoft Access.

Topics

#Compact and Repair#database corruption#network sharing#Memo fields

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice