DEPARTTMENT table

Posted on by Leakey

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

This question has been answered.

Get Answer