Free Preparation Discussions
MENU
Microsoft Exam 77-885 Topic 1 Question 16 Discussion
Topic #: 1
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You are working on a database named Orders created in Microsoft Office Access 2010. This database is located on a network. You want to assign a password so that unauthorized users cannot open the database. In which of the following modes will you open the database to accomplish the task?
In order to accomplish the task, you should open the database in open exclusively mode. The database is located on a network; therefore, you need to ensure that no one is using it. After opening the database in open exclusive mode, you can prevent unauthorized users from opening the database by assigning a password.
Answer D is incorrect. When a database is opened in open mode, it is shared with all users and all of them can insert, modify, and delete data from the database.
Answer B is incorrect. When a database is opened in open read-only mode, data can be viewed but data cannot be inserted, modified, or deleted. Other users can perform all tasks on the database.
Answer C is incorrect. When a database is opened in open exclusive read-only mode, data can be viewed but data cannot be inserted, modified, or deleted. Other users can also open the database, but the database will be opened in read-only mode.
Currently there are no comments in this discussion, be the first to comment!