LU List All Employees Whose Position Begins with Greenhouse Question

User Generated

EZP2019

Business Finance

Liberty University

Description

Unformatted Attachment Preview

mile Home myLU х Bb McGraw-Hill Campus – 202140 F X MSIMnet - Assignment 23: Access х S Ask a new question - Studypool X + liberty.simnetonline.com/sp/assignments/projects/details/6625834 ::: Apps M Gmail YouTube Maps Nexus mods and co... PS3 ROMs & ISO -... Student Portal | Main Dolphin Emulator -... There's Plenty to Ex... Need for Speed Car... Reading list Mc Graw Hill SIMnet ASSIGNMENTS LIBRARY GRADES Villanueva, Chelsea To LMS C 1. Open the start file AC2019-Challenge Yourself-3-3. 2. If the database opens in Protected View, click the Enable Content button in the Message Bar at the top of the database so you can modify it. 3. Create a new query named: Greenhouse TechsFT 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. 4. Export the Greenhouse TechsFT query to an Excel spreadsheet. a. O Name the Excel file: Greenhouse TechsFT b. Include formatting and layout. c. O Save the export steps with the name: GreenhouseTechsFTExport 5. Create a new query named: NewPlants a. Add all the fields from the Plants table except Scientific Name. b. The query should list all white or blue colored plants whose Date Planted is greater than or equal to 1/1/2019. c. O Modify the query design so results are sorted by values in the DatePlanted field with the newest plants listed first. d. O Run the query to review the results. There should be three records in the results. e. O Save and close the query. 6. Export the NewPlants query to a text file. a. O Name the text file: NewPlants b. O Use Tab as the delimiter. c. Include the field names in the first row. d. O Save the export steps with the name: NewPlants Export Reset Progress U Back to top mily Home | myLU х Bb McGraw-Hill Campus – 202140 F. X M SIMnet - Assignment 23: Access х S Ask a new question - Studypool X + liberty.simnetonline.com/sp/assignments/projects/details/6625834 :: Apps M Gmail YouTube Maps Nexus mods and co... PS3 ROMs & ISO -... Student Portal | Main Dolphin Emulator -... There's Plenty to Ex... Need for Speed Car... Reading list Mc Graw Hill SIMnet ASSIGNMENTS LIBRARY GRADES Villanueva, Chelsea To LMS C 7. Create a new query named: RedPlantSale a. Add the following fields from the Plants table to the query: CommonName, PrimaryColor, Purchase Price b. Select only those plants with a red color, but don't show this field in the query results. c. Add a calculated field that displays a sale price that is 75 percent of the purchase price. Hint: Use an expression that calculates the value of the Purchase Price field multiplied by 0.75. Use the name SalePrice for the new field. d. O Run the query to review the results. There should be five records in the results. e. Save and close the query. 8. Use the Find Unmatched Query Wizard to create a new query that identifies the plants that have no entry in the MaintenanceLog. a. Include all fields from the Plants table except the Plant|D. b. O Name this query: PlantsMissingMaintenance c. Review the query results. There should be 15 records in the results. d. Close the query. 9. Create a new parameter query named: PlantsByColor a. Add the following fields from the Plants table to the query: CommonName, PrimaryColor, Date Planted, Purchase Price b. Configure the PrimaryColor field so the user is prompted to enter the primary plant color with this message: Enter plant color c. Test the query using the color violet. There should be three records in the results. d. O Save and close the query. 10. Open the MaintenanceLog table. Apply a filter that shows only those plants that have been watered and pruned. Close the table. There should be one record in the results. 11. Close the database and exit Access. 12. Upload and save your project file. 13. Submit project for grading. Reset Progress U Back to top myle Home | myLU х Bb McGraw-Hill Campus – 202140 F. X M SIMnet - Assignment 25: Access х S Ask a new question - Studypool X + liberty.simnetonline.com/sp/assignments/projects/details/6625835 Apps M Gmail YouTube Maps Nexus mods and co... PS3 ROMs & ISO -... Student Portal Main Dolphin Emulator -... There's Plenty to Ex... Need for Speed Car... Reading list Mc Graw Hill SIMnet ASSIGNMENTS LIBRARY GRADES Villanueva, Chelsea To LMS C 1. Open the start file AC2019-Challenge Yourself-4-3. 2. If the database opens in Protected View, click the Enable Content button in the Message Bar at the top of the database so you can modify it. 3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 4. Create a Single Record form using the Plants table as the record source. Save the form with the name PlantsSingleForm and close it. 5. Create a Multiple Items form using the Plants table as the record source. Save the form with the name PlantsMultipleForm and close it. 6. O Create a Split form using the Maintenancelog table as the record source. Save it with the name MaintenanceLogSplit and close it. 7. Use the Form Wizard button to create a form showing employee information in the main form with a subform showing related maintenance records. a. Add the following fields to the form in this order: From the Employees table: Employee D, LastName, FirstName, Weekly Hours From the MaintenanceLog table: MaintenanceDate, Plant, Watered, Inspected, Pruned b. Organize the form by the Employees table with data from the MaintenanceLog table as a subform. c. Format the subform as a Datasheet form. d. O Name the main form: EmployeeLog e. O Name the subform: EmployeeLogSubform f. Review the form in Form view, and then close it. 8. Create a form from scratch in Layout view. a. Start with a new blank form in Layout view. Save the form with the name: EmployeeDetails b. Add the following fields from the Employees table to the form in this order: Employeeld, LastName, FirstName c. Apply the Slice theme to the database. d. O Save and close the form. Reset Progress U Back to top myle Home | myLU х Bb McGraw-Hill Campus – 202140 F. X M SIMnet - Assignment 25: Access х S Ask a new question - Studypool X + liberty.simnetonline.com/sp/assignments/projects/details/6625835 ::: Apps M Gmail YouTube Maps Nexus mods and co... PS3 ROMs & ISO-... Student Portal Main Dolphin Emulator -... There's Plenty to Ex... Need for Speed Car... Reading list Mc Graw Hill SIMnet ASSIGNMENTS LIBRARY GRADES Villanueva, Chelsea To LMS C 9. Add controls to the MaintenanceLog form. a. Open the MaintenanceLog form in Layout view. b. O Move the plant label and bound text control above the Employee controls. c. Add the Inspected field immediately below the Watered control. d. Add the Pruned field immediately below the Inspected control. e. There is an extra row in the form layout. Delete it. 10. Format controls in the MaintenanceLog form. a. Change the MaintenanceDate label to: Date b. Change the font color for all the label controls to the standard color Maroon (the fifth color from the right in the first row of standard colors). c. Modify the MaintenanceDate bound text box control to use the Long Date format. d. Add the title Maintenance Log to the form header. Be sure to include a space between the words in the title. e. O Save the form and close it. 11. Close the database and exit Access. 12. Upload and save the project file. 13. O Submit project for grading. SUPPORT FOLLOW MCGRAW HILL Reset Progress Back to top SIMnet Blog System Requirements Test Technical Support SIMnet Instant Help Platform Status
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.
View attached ...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags