Create a new query named: GreenhouseTechsFT


  1. 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 20. 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. There should be 16 records in the results.
    f. Save and close the query.
  2. Export the GreenhouseTechsFT query to an Excel spreadsheet.
    a. Name the Excel file: GreenhouseTechsFT
    b. Include formatting and layout.
    c. Save the export steps with the name: GreenhouseTechsFTExport
  3. 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 or equal to 1/1/2019.
    c. Modify the query design so results are sorted by values in the DatePlanted field with
    the newest plants listed first.
    d. Run the query to review the results. There should be three records in the results.
    e. Save and close the query.
  4. Export the NewPlants query to a text file.
    a. Name the text file: NewPlants
    b. Use Tab as the delimiter.
    c. Include the field names in the first row.
    d. Save the export steps with the name: NewPlantsExport

The post Create a new query named: GreenhouseTechsFT appeared first on My Assignment Online.



This essay is written by:

Prof. SirMojo Verified writer

Finished papers: 435

Proficient in:

English, History, Business and Entrepreneurship, Nursing, Psychology, Management

You can get writing help to write an essay on these topics
100% plagiarism-free

Hire This Writer
© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
How to Avoid Plagiarism
  • Use multiple resourses when assembling your essay
  • Use Plagiarism Checker to double check your essay
  • Get help from professional writers when not sure you can do it yourself
  • Do not copy and paste free to download essays
Get plagiarism free essay
Loading...