Access 2019 Skills Approach Assignment
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
Access 2019 Skills Approach – Ch 3 Challenge Yourself 3.3
EXCEL
Need the assignment completed from the instructions, Need this finished within about 24 hoursTechnical Assignment-Access Database 2019 instructions
Home>Business & Finance homework help> Access 2019 Skills Approach – Ch 3 Challenge Yourself 3.3
11/22/2020 SIMnet – Access 2019 Skills Approach – Ch 3 Challenge Yourself 3.3https://uwyo.instructure.com/courses/541237/assignments/4741784 1/3
() Print Info
Student Name: Phelps, Dalton R
Student ID: dphelps4
Username: dphelps4 Access 2019 Skills Approach – Ch 3 Challenge Yourself 3.3 COURSE NAME IMGT 1400 Fall 2020 | IMGT 1400-01 Fall 2020
Start Date: 11/02/2012:00 AMUS/Mountain Due Date: 11/23/2011:59 PMUS/Mountain End Date: 11/25/2011:59 PMUS/Mountain
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 tab-delimited text file.
Skills needed to complete this project:
Using the Simple Query Wizard (Skill 3.1) Creating a Query in Design View (Skill 3.2) Adding Text Criteria to a Query (Skill 3.3) Adding Numeric and Date Criteria to a Query (Skill 3.4) Using AND in a Query (Skill 3.5) Specifying the Sort Order in a Query (Skill 3.9) Exporting Data to Excel (Skill 3.16) Using OR in a Query (Skill 3.6) Combining AND and OR in a Query (Skill 3.7) Exporting Data to a Text File (Skill 3.17) Hiding and Showing Fields in a Query (Skill 3.10) Adding a Calculated Field to a Query (Skill 3.8) Finding Unmatched Data Using a Query (Skill 3.12) Using a Parameter Query (Skill 3.11) Filtering Data Using AutoFilter (Skill 3.14) Filtering Data Using Filter by Selection (Skill 3.15)
1. Open the start file AC2019-ChallengeYourself-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: GreenhouseTechsFT
https://uwyo.simnetonline.com/sp/embed/
11/22/2020 SIMnet – Access 2019 Skills Approach – Ch 3 Challenge Yourself 3.3https://uwyo.instructure.com/courses/541237/assignments/4741784 2/3
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 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
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
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.
6. 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
7. Create a new query named: RedPlantSale a. Add the following fields from the Plants table to the query: CommonName,
PrimaryColor, PurchasePrice 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 PurchasePrice field multiplied by 0.75. Use the name SalePrice for the new field.
d. 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 PlantID. b. Name this query: PlantsMissingMaintenance
11/22/2020 SIMnet – Access 2019 Skills Approach – Ch 3 Challenge Yourself 3.3
https://uwyo.instructure.com/courses/541237/assignments/4741784 3/3
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, DatePlanted, PurchasePrice 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. 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.
RUBRIC
QUALITY OF RESPONSE NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
CLICK ON THE LINK HERE: https://www.perfectacademic.com/orders/ordernow
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!!