For Online Class Help or Private Tutoring Service email us at [email protected] or WhatsApp us at +1 (781) 656-7669

Homework Provider

 
  • Take My Class
  • Take My Exam
  • How It Works
  • Solutions
    • Questions
  • Testimonials
  • Blog
  • Who Are We
  • Contact Us
  • Take My Class
  • Take My Exam
  • How It Works
  • Solutions
    • Questions
  • Testimonials
  • Blog
  • Who Are We
  • Contact Us
  1. Home
  2. Questions
  3. Liberty BUSI 201 Assignment 25 Access 2016 Challenge Yourself 4.3 Answers Solutions

Liberty BUSI 201 Assignment 25 Access 2016 Challenge Yourself 4.3 Answers Solutions

Complete many different versions to get an A on your grade!

Download it for more and ace on your assignments!

Challenge Yourself 4.3

1. Open the start file AC2016-ChallengeYourself-4-3.

2. If necessary, enable active content by clicking the Enable Content button in the Message Bar.

3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.

4. 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 30. 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.

take-my-online-class-thumbnail
Play Video
pay-someone-to-take-my-online-class

Name: Jennifer Lucas
Status: Online ⬤
Classes Taken: 3878
Ratings: ⭐⭐⭐⭐⭐

Hire Me

STATUS

f. Save and close the query.

5. 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

6. 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/2016.

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.

e. Save and close the query.

7. 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. Do not save the export steps.

8. 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 80 percent of the purchase price. Hint: Use an expression that calculates the value of the PurchasePrice field multiplied by 0.8. Use the name SalePricefor the new field.

d. Run the query to review the results.

e. Save and close the query.

9. 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

c. Close the query.

10. 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.

d. Save and close the query.

11. Open the MaintenanceLog table. Apply a filter that shows only those plants that have been watered and pruned. Save and close the table.

12. Save the form and close it.

13. Close the database and exit Access.

14. Upload and save the project file.

15. Submit project for grading.

Facebook
Twitter
Reddit
Pinterest
WhatsApp
Email
pdf-answers
Get Solved Answers
$2.99
Add to cart

GET QUICK PRICE ESTIMATE FOR THIS TASK

WHY CHOOSE US

  • Over 300 Experts to Work on Your Papers
  • 100% Privacy and Confidentiality
  • Amazing Discounts and Special Offers
  • Delivery within Every Deadline Level
  • Secure Payment Process
  • High-Quality Papers
  • 24/7 Live Customer Support
  • Free Revisions If Required
  • Fair & Cheap Prices
  • Rated 4.9/5 By Students

COMPLETED TASKS

SOCS 325 Week 8 Final Exam (Version 2)

July 13, 2020

SOCS 325 Week 8 Final Exam (Version 1)

July 13, 2020

SOCS 325 Week 8 Final Exam (Collection)

July 13, 2020

SOCS 325 Week 8 Collaborative Group Project Discussion

July 13, 2020

SOCS 325 Week 7 Bundle: Assignments + Group Project + Discussions

July 13, 2020

SOCS 325 Week 6 Bundle: Assignments + Discussions

July 13, 2020

SOCS 325 Week 5 Bundle: Assignments + Discussions

July 13, 2020

SOCS 325 Week 4 Midterm (Version 4)

July 13, 2020

Homework Provider

Facebook-f Twitter Pinterest Whatsapp Reddit Envelope

WE ACCEPT

PayPal
VISA Light
AMERICAN EXPRESS LIGHT
Bitcoin
  • Take My Online Class
  • Do My Case Study
  • Take My Online Exam
  • Online Class Help
  • Do My Homework
  • Take My Online Test
  • Original Homework Help
  • Premium Plagiarism Checker
  • Take My Midterm Exam
  • Research Paper Writing
  • Case Study Writing Help
  • Dissertation Writing Service
  • Online Coursework Help
  • Pay Someone To Write My Paper
  • Pay For Online Classes
  • Programming Classes Help
  • MyMathLab Answers
  • MyStatLab Answers
  • MyAccountingLab Answers
  • Need Help With Online Class
  • Cheap Assignment Help
  • Write My Online Essay
  • Online Student Problems
  • Math Homework Help

Contact Us

  • [email protected]
  • WhatsApp (781) 656-7669
  • twitter.com/hwp_helper
  • fb.com/homeworkprovidercom
  • Privacy Policy
  • Terms of Use
  • DMCA
  • Cookie Policy
  • Money Back Guarantee
  • Premium Plagiarism Checker
  • Contact Us

HomeworkProvider.com is not endorsed or affiliated by any university or college. The services provided are meant to assist the client by providing a guideline and the product provided is intended to be used for research or study purposes.

© 2013-2020 HomeworkProvider. All rights reserved.

ORDER THIS
WHATSAPP

Yay! You are just one step away to get rid of homework stress

  • How It Works
  • Testimonials
  • We are committed to ensuring that your information is secure with us
hire-an-expert-to-do-my-exam

Don't Waste Your Time Searching For Old Plagiarized Courses

Get Your Job Done By Our Anonymous Quality Experts

  • How It Works
  • Reviews
  • 24/7 Support
doc icon homework provider

CIS 155 Lab Help, Leslie​
Thank you for doing my CIS 115 lab. Homework Provider is the best.

Rated By Client
 5/5
doc icon homework provider

Dream Service, William
Thanks God, you came to my rescue. Thanks for your help.

Rated By Client
 5/5
doc icon homework provider

Mind blowing service, Eddie
I could have failed quite a few exams if you guys did not help me

Rated By Client
 5/5
doc icon homework provider

Got A grade in final exam, John
I still couldn’t believe I got an A grade in my exam. Highly vouched service.

Rated By Client
 5/5
doc icon homework provider

Linda, opted for private tutoring
Subscribed to get online class help for devry acct 212 week 1-8 class​​

Week 5 65%
doc icon homework provider

Acct Course Project, Ryan
Thanks a lot to my writer who followed all my requirements.

Rated By Client
 5/5
xls-icon

Genuine service, Steven
The research paper was much more than I expected! Thanks a lot.

Rated By Client
 4.5/5
doc icon homework provider

Karen, opted for private tutoring
Subscribed to get online class help for liberty BUSI 536 week 1-8 class.

Week 7 88%
doc icon homework provider

Marcus, opted for private tutoring
Subscribed to get online class help for ashford psy week 1-5 class.

Week 3 58%
doc icon homework provider

I got A grade in class, Amanda
with the help of homework provider I made it to pass my acct 505 class.

Rated By Client
 5/5