You have created a database in Microsoft Access 2010 that contains several tables, queries, forms, and reports. This database is available for use by several organizations, but the organizations do…

The correct answer is B. Save the database as an ACCDE file. You should save the database as an ACCDE file and then distribute it. When you save the database as an ACCDE file, it compiles and compacts the resulting database. Users who use the ACCDE file cannot change the form and report designs. They can only view forms and reports…

Managing the Access Environment

Question

You have created a database in Microsoft Access 2010 that contains several tables, queries, forms, and reports. This database is available for use by several organizations, but the organizations do not want their members to change the form and report designs. What will you do?

Options

ASave the database as an ACCDC file.
BSave the database as an ACCDE file.
CSave the database as an ACCDR file.
DSave the database as an ACCDB file.

How the community answered

(41 responses)

A
2% (1)
B
83% (34)
C
5% (2)
D
10% (4)

Explanation

You should save the database as an ACCDE file and then distribute it. When you save the database as an ACCDE file, it compiles and compacts the resulting database. Users who use the ACCDE file cannot change the form and report designs. They can only view forms and reports, update information, and run queries. Answer: D is incorrect. If you save the database as an ACCDB file, users can create, modify, or delete any database object. Answer: C is incorrect. If you save the database as an ACCDR file, users cannot view, create, modify, or delete any database object. Answer: A is incorrect. The ACCDC file contains one database that has been compressed.

Topics

#ACCDE file format#database security#design protection#file formats

Community Discussion

No community discussion yet for this question.

Full 77-885 Practice