Access Work 2019

WA.4.15 you have built an extensive database for Wedgewood Pacific (WP.accdb).You will now use it to build some prototype forms and reports so that the users at WP can evaluate the proposed database. In this case, there is no need to restructure the database.

A. Create a report that allows users to view and edit employee data. The form should show information about the employee, the department that he or she works for, and which projects the employee is assigned to.

B. Create a report that displays the employee information shown on the form you created in part A. The report should show this information for all users, sorted alphabetically in ascending order by LastName.

C. create a form that allows users to view and edit project data. The form should show information about the project and the department that is responsible for the project, and it should list all employees who are assigned to work on that project.

D. Create a report that displays the project information shown on the form you created in part C. The report should show this information for all projects, sorted in ascending order by ProjectID.