Exercises AW.6.1 Use the Wedgewood Pacific (WP) database developed in previous s

Question

Exercises

AW.6.1 Use the Wedgewood Pacific (WP) database developed in previous sections of “The Access Workbench” to answer the following questions.

A. Analyze the data in the WP database tables (particularly DEPARTMENT and EMPLOYEE), and create a database security plan, using Figure 6-16 as an example.

B. If you have not already created a My-Trusted-Location folder, follow the steps in this chapter’s section of “The Access Workbench” to do so now.

C. Make a copy of the WP.accdb file in the My-Trusted-Location folder, and name it WP-AW06-01.accdb. Open the WP-AW06-01.accdb database to confirm that it opens without displaying the Security Warning bar, and then close the database.

D. Make a copy of the WP.accdb file in the My-Trusted-Location folder, and name it WP-AW06-02.accdb. Encrypt the WP-AW06-02.accdb database with the password AW06EX+password. Close the WP-AW06-02.accdb database, and then reopen it to confirm that it opens properly using the password. Close the WP-AW06-02.accdb database.

E. If you have not already created the Digital-Certificate-AW06-01 digital certificate, follow the steps in this chapter’s section of “The Access Workbench” to do so now.

F. Make a copy of the WPC.accdb file in the My-Trusted-Location folder, and name it WP-AW06-03.accdb. Create an ACCDE version of the WP-AW06-03.accdb database. Create a signed package using the WP-AW06-03.accde database and the Digital-Certificate-AW06-01 digital certificate.

G. If you have not already created a My-Distributed-Databases folder, follow the steps in this chapter’s section of “The Access Workbench” to do so now.

H. Make a copy of the WP-AW06-03.accdc file in the My-Distributed-Databases folder. Extract the WP-AW06-03.accde file into the folder, and then open it to confirm that the database opens properly. Close the database.

Explanation / Answer

ANSWER:

A)

Database Security plan should consists of below points :

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.