Question
Database Concepts 6th Edition CHAPTER 6, ACCESS Workbench Exercises, Page 387 All of that exercise. / AW.6.1 letters A thru H. Thank you! AW.6.1 Use
Database Concepts 6th Edition
CHAPTER 6, ACCESS Workbench Exercises, Page 387 All of that exercise. / AW.6.1 letters A thru H. Thank you! AW.6.1 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 chapters 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 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 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 chapters 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started