Question: Create a new query named: GreenhouseTechsFT a. Add all the fields from the employees table. b. The query should list all employees whose position begins

Create a new query named: GreenhouseTechsFT

a. Add all the fields from the employees table.

b. The query should list all employees whose position begins with the word greenhouse and whose weekly hours are greater than or equal to 30. Hint: include a wildcard character in the criterion for the position field.

c. modify the query design so results are sorted alphabetically by last name.

d. add the MaintenanceLog table to this query and include the MaintenanceDate field after the WeeklyHours Field.

e. run the query to review the results.

f. save and close

I just need to know how to do each step. No need to do it for me. just guide me please!

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 General Management Questions!

From the perspective of a Magna Class A shareholder, what are the primary costs are benefits of Magna's dual-class ownership structure in 2010? Please be specific and also relate those costs and...

I have an access project due tonight. Attached are the instructions and the document to work off of. Thank you in advance! A Skills Approach: Access 2016 Chapter 4: Using Queries and Organizing...

Create a new query named: GreenhouseTechsFT a. Add all the fields from the employees table. b. The query should list all employees whose position begins with the word greenhouse and whose weekly...

4. Create a new query named: GreenhouseTechsFT a. Add all the fields from the Employees table b) The query should list all employees whose Position begins with the word greenhouse and whose weekly...

6. Create a new query named: NewPlants a. Add all the fields from the Plants table except ScientificName. b. The query should list all white or blue colored plants whose DatePlanted is greater than...

5. Create a new query named: NewPlants a.[_ Add all the fields from the Plants table except ScientificName. b.[ The query should list all white or blue colored plants whose DatePlanted is greater...

In this project you work with a greenhouse database. Improve the functionality of this database by creating a variety of queries and exporting the query results to both an Excel spreadsheet and a...

Create a new query named: GreenhouseTechsFT Add all the fields from the Employees table. The query should list all employees whose Position begins with the word greenhouse and whose weekly hours are...

I have this project that I am completely lost on. We're suppose to open Access and follow directions. Open the start file AC2019-ChallengeYourself-3-3 . If the database opens in Protected View, click...

a. a. 3. Create a new query named: Greenhouse Techs FT Add all the fields from the Employees table. b. The query should list all employees whose Position begins with the word greenhouse and whose...

A company has just paid its first dividend of $1.27. Next year's dividend is forecast to grow by 6 percent, followed by another 6 per cent growth in year two. From year three onwards dividends are...

Low-energy lightbulbs cost $3.50, have a life of nine years, and use about $1.60 of electricity a year. Conventional lightbulbs cost only $.50, but last only about a year and use about $6.60 of...

Waiters and waitresses are generally paid very low hourly wages and receive most of their compensation from customer tips Theoretically a restaurant owner could pay workers a higher wage raise menu...

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...