Question: Add the MaintenanceLog table to this query and include the MaintenanceDate field after the WeeklyHours field. Run the query to review the results. There should

Add the MaintenanceLog table to this query and include the MaintenanceDate field after the WeeklyHours field.
Run the query to review the results. There should be 16 records in the results.
Save and close the query.
Export the GreenhouseTechsFT query to an Excel spreadsheet.
Name the Excel file: GreenhouseTechsFT
Include formatting and layout.
Save the export steps with the name: GreenhouseTechsFTExport
Create a new query named: NewPlants.
Add all the fields from the Plants table except ScientificName.
The query should list all white or blue colored plants whose DatePlanted is greater than or equal to 1/1/2019.
Modify the query design so results are sorted by values in the DatePlanted field with the newest plants listed first.
Run the query to review the results. There should be three records in the results.
Save and close the query.

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!