In the Access Workbench Exercises in Chapters 1 and 2, you created a database for Wedgewood Pacific (WP) of Seattle, Washington. In this set of exercises, youll: 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.

AW.3.1 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, 2017? 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 OfficePhone.

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

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

H. Who are the employees assigned to projects run by the Sales and Marketing department? Show ProjectID, ProjectName, Department, and DepartmentPhone.

I. Show EmployeeNumber, LastName, FirstName, and OfficePhone. Sort by ProjectID in ascending order.

J. How many projects are being run by the Sales and Marketing department? Be sure to assign an appropriate column name to the computed results.

K. What is the total MaxHours of projects being run by the Sales and Marketing department? Be sure to assign an appropriate column name to the computed results.

L. What is the average MaxHours of projects being run by the Sales and Marketing department? Be sure to assign an appropriate column name to the computed results.

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.