DEPARTTMENT table

1. Show all the data from DEPARTTMENT table and order by DepartmentName. Save the query as qry_DEPT. 2. Show all the data from EMPLOYEE table and order by DepartmentName. Save the query as qry_EMP. 3. Show all the data from PROJECT table and order by DepartmentName. Save the query as qry_PROJ. 4. Show all the data from ASSIGNMENT table and order first by ProjectID, and then by EmployeeNumber. Save the query as qry_ASGN, 5. What are the ProjectID, ProjectName, StartDate, and EndDate values of projects in the PROJECT table? Save the query as qry_PROJ_DATE 6. Show the employees’s EmployeeNumber, FirstName, LastName, Position, OfficePhone, and EmailAddress for those who work in the InfoSystems department. Save the query as qry_EMP_IS 7. Show all the data for project which are completed within June 2017 (the EndDate falls in June 2017). Save the query as qry_PROJ_JUNE2017