BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 77-885 Topic 4 Question 20 Discussion

Actual exam question for Microsoft's exam
Question #: 20
Topic #: 4
[All Questions]

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. The computer contains a database named Order1 created in Microsoft Office Access 2010. You want to open the database in shared mode so that all users can insert, modify, and delete data from the database. In which of the following modes will you open the database to accomplish the task?

Show Suggested Answer Hide Answer
Suggested Answer: C

In order to accomplish the task, you should open the database in open mode. When you open the database in this mode, it is shared with all users and all of them can insert, modify, and delete data from the database.

Answer A is incorrect. When a database is opened in open exclusive mode, other users cannot open it unless the current user closes the database and opens it normally.

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


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel