For each project, create a report to show project code, project name, project completion date, and following information on employees assigned to the project $($last name, first name, employee ID$,$ gender and the location of the department they are assigned to$).$

Steps for creating report:

$1.$ Select $$Create report by using wizard$($Create$>>$Report Wizard$)$

$2.$ Select all the fields from Table: Project

Following fields from Table: Employee

$$ First Name

$$ Last Name

$$ Employee ID

$$ Gender

Following Fields from Table: Department

$$ Department Location

$3.$ Select View your Data $$by Projects$$ in the next window.

$4.$ Do NOT add any Groupings Level in the next window.

$5.$ Select sort records according to $$last name$$ in ascending order in the next window.

$6.$ Select $$Stepped$$ Layout, $$Portrait$$ Orientation, and check $$Adjust the field width so all fields fit on a page$.$

$7.$ Name the Report as $$Projects$.$