WA 3 1 Using Access SQL, create and run queries to answer the questions that follow Save each query using the query name format SQLQuery WAE 3 1 where the sign is replaced by the letter designator of the question For example, the first query will be saved as SQLQuery WAE 3 1 A What projects are in the WP PROJECT table Show all information for each project What are the ProjectID, ProjectName, StartDate, and EndDate values of projects in the WP PROJECT table What projects in the WP PROJECT table started before August 1, 2019 Show all the information for each project What projects in the WP PROJECT table have not been completed Show all the information for each project Who are the employees assigned to each project Show ProjectID, EmployeeNumber, LastName, FirstName, and OfficePhone Who are the employees assigned to each project Show ProjectID, ProjectName, and Department Show EmployeeNumber, LastName, FirstName, and OfficePhone 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 Who are the employees assigned to projects run by the Sales and Marketing department Show ProjectID, ProjectName, Department, and DepartmentPhone Show EmployeeNumber, LastName, FirstName, and OfficePhone Sort by ProjectID in ascending order How many projects are being run by the Sales and Marketing department Be sure to assign an appropriate column name to the computed results 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 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

The Answer is in the image, click to view ...

Question: WA.3.1 Using Access SQL, create and run queries to answer the questions that follow. Save each query using the query name format SQLQuery-WAE-3-1-## where the

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

What projects are in the WP PROJECT table? Show all information for each project.
What are the ProjectID, ProjectName, StartDate, and EndDate values of projects in the WP PROJECT table?
What projects in the WP PROJECT table started before August 1, 2019? Show all the information for each project.
What projects in the WP PROJECT table have not been completed? Show all the information for each project.
Who are the employees assigned to each project? Show ProjectID, EmployeeNumber, LastName, FirstName, and OfficePhone.
Who are the employees assigned to each project? Show ProjectID, ProjectName, and Department. Show EmployeeNumber, LastName, FirstName, and OfficePhone.
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.
Who are the employees assigned to projects run by the Sales and Marketing department? Show ProjectID, ProjectName, Department, and DepartmentPhone. Show EmployeeNumber, LastName, FirstName, and OfficePhone. Sort by ProjectID in ascending order.
How many projects are being run by the Sales and Marketing department? Be sure to assign an appropriate column name to the computed results.
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.
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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Need Some help for The D and E queries for this animal table ANIMAL (AnimalID, NickName, Species, Sex, Age, Exhibit , Keeper ) EXHIBIT (ExhibitName, Environment) KEEPER (KeeperID, LastName,...

I need help with three differnt querys for this animal table A,B,And C ANIMAL (AnimalID, NickName, Species, Sex, Age, Exhibit , Keeper ) EXHIBIT (ExhibitName, Environment) KEEPER (KeeperID, LastName,...

ACCESS WORKBENCH EXERCISES Complete A through L under AW.3.1 using either the QBE or SQL querying method. Your choice. Name queries using 'qry_ItemLetter'. For example, for item A. on page 239 use...

In the "Working with Microsoft Access" Exercises in Chapter 1 and Chapter 2, you created a database for Wedgewood Pacific (WP) of Seattle, Washington. In this set of exercises, you'll: - Create and...

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...

I am having problems with the QBE G query. It does not display all of the employees for each project, instead it only displays one employee for every project. QBE Queries: Using Microsoft Access QBE,...

QBE Queries: Using Microsoft Access QBE, create and run new queries to answer the questions that follow. Save each query using the query name format QBEQuery-#, where the # sign is replaced by the...

Illustrated Access 2013 Unit B: SAM Project 1a Tours Database USING QUERIES PROJECT DESCRIPTION You work for an adventure tour company that operates recreational hiking, biking, and walking tours in...

i need to follow the instruction in tge first document to edit the access document GO16_AC_VOL1_GRADER_CAP_AS - Inventory Supplies Project Description: In this project, you will apply skills you...

(1) (2) (3) Find f'(x) and simplify if possible. f(x) = 2x5 - 5x + 6x - 9 4x-1 f(x) = f(x) = x. Find h'(x) if Assume that f(x) and g(x) are both differentiable functions for all 3x+4 x-2x+7 x f(x)...

When crystalline maltose is dissolved in water, the initial specific rotation changes and gradually reaches an equilibrium value. Explain.

According to _ _ _ _ _ _ _ _ _ _ , the value of a company is unrelated to its capital structure. Group of answer choices M&M Proposition 2 , with no tax the static theory of capital structure the...

1. Using the high-low method, calculate the variable rate per hour and the fixed cost for the nursing care activity. Comment on your results. (5 marks) 20 2. Upon looking into the events that...

2. Show the trainees how to do it without saying anything.

1. Tell the trainees the objective of the task and ask them to watch you demonstrate it.

1. A policy statement that describes the purpose of OJT and emphasizes the companys support for it.