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.
ANSWER:
A)
Database Security plan should consists of below points :
Exercises AW.6.1 Use the Wedgewood Pacific (WP) database developed in previous sections of “The Access Workbench”...
For this set of Review Questions, we will create and use a database for the Wedgewood Pacific Corporation (WPC) that is similar to the Microsoft Access database we created and used in Chapters 1 and 2. Founded in 1957 in Seattle, Washington, WPC has grown into an internationally recognized organization. The company is located in two buildings. One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and Information Systems departments. The...