Exercises AW.6.1 Use the Wedgewood Pacific (WP) database developed in previous sections of The Access Workbench…

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 chapters 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 chapters 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 chapters 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.