1) Generate a form that allows the users to view and edit the employee data. The form should display the information related to employee, the department that s/he works in, and to which projects the employee is assigned.
2) Form a report that show the employee information, show on the form you generated in 1) above. The report should display this information for all the users, sorted alphabetically in the ascending order by LastName.
3) Create a form that allows the users to view and edit the project data. The form should show the information regarding the project and department that is responsible for project, and it should list all employees who are assigned to work on that project.
4) Create a report that displays the project information shown on the form you generated in 3) above. The report should show this information for all the projects, sorted in ascending order by ProjectID.