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 grader project chapter 3

25/12/2020 Client: saad24vbs Deadline: 24 Hours

Grader - Instructions Access 2019 Project


Exp19_Access_Ch03_Cap - Brilton Madley Games 1.0

Project Description:

Brilton Madley, a board game manufacturer, hired a new CEO. She asked for your assistance in providing summaries of data that took place before she started with the company. To help her with her strategic planning, you will create queries to perform data analysis. Based on your meeting, you plan on creating four queries. One query will find orders with minor delays. Another query will summarize company revenue and cost by country. A third query will be used to help evaluate payments made by customers on their orders. The final query will calculate the total sales by sales representative title.


Steps to Perform:

Step


Instructions


Points Possible


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.


0


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.


5


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.


10


4


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


5


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.


5


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.


5


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.


4


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.


10


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.


11


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.


10


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.


5


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


10


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.


10


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.


5


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.


5


16


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


0


Total Points


100



Created On: 07/11/2019 1 Exp19_Access_Ch03_Cap - Brilton Madley Games 1.0


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Writer Writer Name Offer Chat

Writers are writing their proposals. Just wait here to get the offers for your project...

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

Similar Homework Questions

Lending club data science project - IOM future of nursing report and nursing - Oracle dba skills resume - Present worth method of comparison - Excel Homework - Dapps rule - How do you write a ballad - Father father aaron pelsue lyrics - Basic requirements of teaching - Competitive And Technological Forces - Philosophy of therapeutic recreation - Jhs little black amp box manual - Jessica the merchant of venice - Brooke bond lipton india ltd merged - INFO321 Assignment 6 - Cherry pink and apple blossom white musical ideas - Temple university powerpoint template - Can you claim eastlink on tax - A job order cost sheet for ryan company is shown below. - I need a 1500 words on Instructions - Plan production for a four-month period - Dateline secrets on hot springs drive conclusion - Nurs 6650 midterm exam questions and answers - Youth empowerment project proposal - Argos pet insurance excess - How to measure relative humidity with a thermometer - Lizard evolution virtual lab answer key - Mgt351 week 4 - Graph analysis lab earth science answers - Unilever and ben and jerry's takeover success - How does scrooge change throughout the novel essay - Square root of 52 in surd form - Financial statements effects template to solve problem - Cross manufacturing company chennai tamil nadu - Need help with chemistry homework - In the word claustrophobic phob is the - Hephaestus symbols of power - Rust oleum specialty stainless steel paint - 2009 ap macroeconomics free response answers - Freedom on my mind volume 2 pdf free - Journal Article (680 words) - Organizational Analysis - Plot the supply curve and the demand curve for bicycles - Discussion social behavior - Dikw paradigm nursing - What gives rise to the currency exposure at aifs - Selling expense flexible budget report - Under armour financial analysis - Kurrimine beach fishing club - Creac legal writing example - Practical Connection Assignment - Snap on car hoist - Similarities and differences between freud's and jung's theories of personality - Adding tens and ones - Reply to my peers - What is a system unit used for - Product life cycle examples 2017 - Testout 4.4 6 - Unveiling the Valor of Army Canines Guardians Trained at the Military Dog Center - Project 3 - South pasadena ap chemistry - Writing ASSIGNMENT ( marketing) - Fire service manual volume 1 pdf - Blc reflective essay examples - Riverbed modeler academic edition license - They say i say strategies - Wendy buss kitchen nightmares - 1-6 project one - Kardinya shopping centre redevelopment - Sweatt model - Only about children mcdowall - Seido karate kata list - Bead and button patterns - Was brutus a betrayer or a patriot - High contact and low contact services ppt - Chemistry - Mri department queens hospital romford - Lazarus come forth sermon - Forked river brewing company case study - Mg hcl mgcl2 h2 balanced - Onlinecourses coastlinelive - Hyundai imax seat configuration - Week 1 MKT - AUTHENTIC PAY AFTER SERVICE O835179056 SAFE ABORTION PILLS IN DURBAN STANGER PINETOWN UMLAZI KWAMASHU QWAQWA TONGAAT - Nonmem 7.4 user guide - HW - 2 coments each one 150 words (CITATION AND REFERENCE) - Health Policy : Final Project Milestone Four: Full Analysis - Aco qmax data sheet - Methods exam formula sheet - Devry econ 312 week 3 quiz - Why is the gh spelling inconsistent with etymology - What is the ph of a 0.10 m naoh solution - Lower childhood obesity by 20% using lets move! - Finanance and blockchain - Dan scardino lois and clark - Engineering - On january 1 2017 simon company - Tweed heads rugby league club - Angola life on the farm