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?
A.
Open exclusively
B.
Open read-only
C.
Open exclusive read-only
D.
Open
Explanation:
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.
After opening the database in open exclusive mode, you can prevent unauthorized users from opening the
database by assigning a password.