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?
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.
Currently there are no comments in this discussion, be the first to comment!