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 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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
