Use the Wedgewood Pacific Corporation (WPC) database developed in previous sections of “...

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

A. Analyze the data in the WPC 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 WPC.accdb file in the My-Trusted-Location folder and name it WPC-AW06-01.accdb. Open the WPC-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 WPC.accdb file in the My-Trusted-Location folder and name it WPC-AW06-02.accdb. Encrypt the WPC-AW06-02.accdb database with the password AW06EX+password. Close the WPC-AW06-02.accdb database and then reopen it to confirm that it opens properly using the password. Close the WPC-AW06-02.accdb database.

E. If you have not already created the Digital-Certificate-AW06-001 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 WPC-AW06-03.accdb. Create an AACDE version of the WPC-AW06-03.accdb database. Create a signed package using the WPC-AW06-03.accde database and the Digital-Certificate-AW06-001 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 WPC-AW06-03.accdc file in the My-Distributed-Databases folder. Extract the WPC-AW06-03.accde file into the folder and then open it to confirm that the database opens properly. Close the database.