Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Access chapter 3 homework project 1

14/10/2021 Client: muhammad11 Deadline: 2 Day

Grader Project: Access Chapter 3 Capstone - Brilton Madley Games

Follow the instructional steps to finish the project (point values can also be seen using the link below).

1. Start Access. Open the downloaded Access file named Exp19_Access_Ch03_Cap_Brilton_Madley_Games.accdb. Grader has automatically added your last name to the beginning of the filename.

2. Create a query using Query Design. From the Customers table, include the fields FirstName, LastName, and Phone (in that order). From the Orders table, include the fields OrderID, OrderDate, and ShippedDate (in that order). Run the query and then examine the records. Save the query as Shipping Efficiency.

3. Add a calculated field named DaysToShip to calculate the number of days taken to fill each order. (Hint: the expression will include the OrderDate and ShippedDate fields; the results will not contain negative numbers.) Run the query and then examine the results. Save the query.

4. Add criteria to limit the query results to include any order that took more than 30 days to ship.

5. Add the Quantity field from the Orders table and the ProductName field from the Products table to the query (in that order). Sort the query by ascending LastName.

6. Add the caption Days to Ship to the DaysToShip field. Switch to Datasheet view to view the final results. Save and close the query.

7. Create a query using Query Design and add the Customers, Orders, and Products tables. Add the Country field from the Customers table. Set the field’s Total row to Group By. Save the query as Revenue and Cost by Country.

8. Add a calculated field in the second column. Name the field TotalRevenue. This field should multiply the quantity ordered (from the Orders table) by the unit price for that item (from the Products table). Format the calculated field as Currency and change the caption to Total Revenue. Change the Total row for the TotalRevenue field to Sum.

9. Add a calculated field in the third column. Name the field TotalCost. The field should multiple the quantity ordered (from the Orders table) by the unit cost for that item (from the Products table). Format the calculated field as Currency and add a caption of Total Cost. Change the Total row to Sum. Run the query. Save the query. Return to Design view.

10. Add the OrderDate field and criteria to that field so that only orders made between 7/1/2018 and 12/31/2018 are displayed. Change the Total row to Where. This expression will display only orders that were completed during the second half of 2018. Run the query and view the results. Save and close the query.

11. Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and LastName fields. Move the TotalRevenue field to the end. Rename the TotalRevenue field to OrderTotal. Change the caption to Order Total.

12. Add a new field using the Expression Builder named SamplePayment. Insert the Pmt function with the following parameters:
• Use .05/12 for the rate argument (5% interest, paid monthly)
• Use the number 12 for the num_periods argument (12 months)
• Use the calculated field OrderTotal for the present_value
• Use 0 for both future_value and type

13. Change the Total row to Expression for the SamplePayment field. Change the Format for the SamplePayment field to Currency. Run the query and verify the second order(with LastName Sparks) has a sample payment of $26.80. Note: it will display as a negative number. Save and close the query.

14. Create a copy of the Revenue and Cost by Country query named Revenue by Sales Rep. Switch to Design view of the new query and remove the entire Customers table, the TotalCost, and OrderDate fields. Add the Sales Reps table. Add the Title field from the Sales Reps table and move it to the front of the TotalRevenue field.

15. Run the query and then examine the summary records; there should be 4 Titles listed. Switch to Design view and change the sort order so that the title with the highest TotalRevenue is first and the title with the lowest TotalRevenue is last. Run the query and verify the results. Save and close the query.

16. Close all database objects. Close the database and then exit Access. Submit the database as directed.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Math Specialist
Academic Master
Phd Writer
Quick Mentor
Assignment Solver
Innovative Writer
Writer Writer Name Offer Chat
Math Specialist

ONLINE

Math Specialist

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$29 Chat With Writer
Academic Master

ONLINE

Academic Master

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$46 Chat With Writer
Phd Writer

ONLINE

Phd Writer

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$40 Chat With Writer
Quick Mentor

ONLINE

Quick Mentor

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$19 Chat With Writer
Assignment Solver

ONLINE

Assignment Solver

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$36 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$25 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Audit evidence is usually considered sufficient when - Rectifier ac to dc calculation - Parkwood day centre alfreton - Kb salt and pepper squid recall - Biometrics week1 db - Rhetorical fallacy in the workplace - HA575 Unit 9 Discussion - Essen of physical anthropology w bind in access code - Old economy traders opened an account to short sell - Luxottica trading and finance ltd - Critical thinking- virtual organization management - Vex pull toy instructions - Code of fair testing practices in nursing education - Legal point of discharge maroondah - Best way to introduce a guest speaker - The form of the chant alleluia vidimus stellam is - Engineering industrial training unsw - Urgent 3 - Livingstone daisy seed pod - Provide a response to the author's message concerning the relationship between food availability and population growth. What do you think about the population and its contribution to the spread of Covid-19 over the past few months. - I am australian poem analysis - Weighing measuring accuracy and precision lab report - Amu engl 102 quiz 1 - Leadership engagement - Motor program theory - What is a cleaning supervisor job description - Help - Health sciences library mcmaster university - Where is boxer eventually taken and what happens to him - Week 2 - In the hall of the mountain king instruments - What is a medieval drama called - Torsion of circular sections lab report - Full block style letter - Maths methods 3 4 - Is magnesium oxide amphoteric - Cr acac 3 ir - Shell oil in nigeria case study answers - Assignment - Phoenix MGT 526 Organizational Chart - Cockatoo feeding dandenong ranges - Phy - Questions to ask your upline - What does daforest stand for - Andrew jackson good evil and the presidency video questions - Blue whale levels of classification - Cafe menu reading strategies - Week 5 Part 2 - Structural Analysis - Zombies reading instructional guide for high interest article answer key - Seismograph lab answer key - Louisiana state university press location - Moorebank sports club menu - How to do t test in graphpad prism 8 - Likert scale interest level - Assignment: Diversity, Equity, and Social Justice - Larry's tax basis in his partnership interest - DISCUSSION- DIALYSIS SAFETY - Scared straight program merced ca - Shut up about harvard main idea - Exercise 8 - Pressing the ____ keyboard shortcut key s selects cell a1 - Business - Behavior management models systems table - Ca oh 2 ch3cooh balanced equation - African animal common name inquizitive - John maxwell 5 levels of leadership book - Ethernet virtual private lan - Obb and bob phase 5 - Financial accounting - HRM 635-ACQUIRING EMPLOYEES - Orpheus in the underworld script - Mensa luxembourg test score chart - Colleges prepare people for life freeman hrabowski - Kiosk manager duties and responsibilities - Colgate palmolive company the precision toothbrush case analysis - What constitutes meaningful compensation for an organ donor - Zweig letter from an unknown woman - Building construction lesson plans - Going upriver at the qingming festival - Job seeker diary centrelink - Bus 311 week 5 final paper - Concorde mindtap - Nicean barks of yore - Financial Markets and Institutions - Erv polster believes that storytelling - Chem1001 worksheet 3 answers - Stat380 Rstudio Lab 8 - The classical theory of motivation suggests that _____ is the sole motivator for workers. - Copper and silver nitrate reaction lab answers - Waves and vibrations lab - Pierce the spaceman worksheet answers - 978 1 259 73278 2 - Disuccsion - How to calculate cash discount and trade discount - Is eye color a mendelian trait - I am presence chart - What is a creative response - Create an annotated bibliography based on the following topic: The impact of space travel on the human body. - How to demonstrate customer service skills