In the “Access Workbench Exercises” in Chapters 1 and 2, you created a database for the...

In the “Access Workbench Exercises” in Chapters 1 and 2, you created a database for the Wedgewood Pacific Corporation (WPC) of Seattle, Washington. In this set of exercises, you’ll:

• Create and run queries against the database by using Access SQL.

• Create and run queries against the database by using Access QBE.

• Create tables and relationships by using Access SQL.

• Populate tables by using Access SQL.

Using Access SQL, create and run queries to answer the questions that follow. Save each query using the query name format SQLQuery-AWE-3-1-## where the ## sign is replaced by the letter designator of the question. For example, the first query will be saved as SQLQuery-AWE-3-1-A.

A. What projects are in the PROJECT table? Show all information for each project.

B. What are the ProjectID, ProjectName, StartDate, and EndDate values of projects in the PROJECT table?

C. What projects in the PROJECT table started before August 1, 2014? Show all the information for each project.

D. What projects in the PROJECT table have not been completed? Show all the information for each project.

E. Who are the employees assigned to each project? Show ProjectID, EmployeeNumber, LastName, FirstName, and Phone.

F. Who are the employees assigned to each project? Show ProjectID, ProjectName, and Department. Show EmployeeNumber, LastName, FirstName, and Phone.

G. Who are the employees assigned to each project? Show ProjectID, ProjectName, Department, and Department Phone. Show EmployeeNumber, LastName, FirstName, and Employee Phone. Sort by ProjectID, in ascending order.

H. Who are the employees assigned to projects run by the marketing department? Show ProjectID, ProjectName, Department, and Department Phone. Show EmployeeNumber, LastName, FirstName, and Employee Phone. Sort by ProjectID, in ascending order.

I. How many projects are being run by the marketing department? Be sure to assign an appropriate column name to the computed results.

J. What is the total MaxHours of projects being run by the marketing department? Be sure to assign an appropriate column name to the computed results.

K. What is the average MaxHours of projects being run by the marketing department? Be sure to assign an appropriate column name to the computed results.

L. How many projects are being run by each department? Be sure to display each DepartmentName and to assign an appropriate column name to the computed results.