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?
A.
Open exclusive
B.
Open read-only
C.
Open
D.
Open exclusive read-only
Explanation:
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.