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

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

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

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:

Custom Coursework Service
Phd Writer
Top Grade Tutor
Helping Hand
Assignment Hut
Isabella K.
Writer Writer Name Offer Chat
Custom Coursework Service

ONLINE

Custom Coursework Service

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$18 Chat With Writer
Phd Writer

ONLINE

Phd Writer

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$16 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$45 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$38 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$39 Chat With Writer
Isabella K.

ONLINE

Isabella K.

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$30 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

Inventory management assessment - Leaders - Acute response to exercise - On a data flow diagram you may - A8 High school behaviors - A dry white season sparknotes - Human growth and development broward college - Plant cell model 3d - Alarmsense sounder beacon base - Common multiples of 6 and 9 - Discussion - Constructing race creating white privilege - Fin 370 week 2 myfinancelab - Merchant category code 5735 - Grade 11 physics exam questions and answers - Dofoodsafely health vic gov au - Carport 7m x 6m - Hilti cast in sockets - Discussion Forum Week 5: economies of scale - Research assistant job description - 5 dysfunctions of a team avoidance of accountability - Ardex cd concrete dressing 40 lb bag - Anti drug legislation matrix - "Civil War" - Among school children yeats analysis - Legal, Ethical, and Risk Issues in Organizations - Parallel sheets of current - Evans technology has the following capital structure - Australian core skills framework practice test - Access chapter 3 homework project 1 - J ezra merkin net worth - Literature 101 - Rochdale occupational health service ltd - Mistakes were made but not by me pdf - Asce 7 10 parapet wind loads - Hesta unique super identifier - List of muis approved halal certification bodies - Discussion question 6 in-cite text - TestOut Networking Pro - Ψ meaning in biology - One page summary - Their eyes were watching god simile - A system of two paint buckets connected by a lightweight rope - Article or video describing a new product in development - Bile acid test normal range dog - Order of magnitude biology - Calcium hydrogen carbonate and nitric acid - Practical Connection Paper - Movie life is beautiful summary - Home in fiction geraldine brooks - Research Paper - Sociology 20 marker structure - Identifying research gaps in literature review - How to preserve polaroids - The adept mind is one that - Turing Machines Assignment - Quiz - Weather forecast script template - Https://www.thenutracafe.com/es/keto-360-slim/ - What Is Philosophy? - Lady audley's secret 2000 - A life insurance company sells a term - Assessment (for Dr. Fattima) - Outline - Maslow's hierarchy of needs the blind side - Assignment Help - Your Academic Lifeline - Area and volume formula sheet - Advantages and disadvantages of honey and mumford learning styles - The buret is filled with the naoh titrant - Beyond compare folder compare - IT Related Questions - The outsiders narrative essay - As of december 31 2017 armani company's financial - What is the ethical issue involving expensive scratch off tickets - How to report logistic regression results apa style - Valence electrons in each group - Flattened sacs in the chloroplasts that contain chlorophyll - How to test redarc brake controller - Corwin corporation case study - The research paper should be based on a topic discussed in the course. - CHRISTIAN SERVANT LEADERS - Persuasive claim pricey hotel breakfast - Guidance on lifting operations in construction when using excavators - Hyperspectral remote sensing ppt - What is composition in a sculpture - Desiree's baby questions for study and discussion answer key - Intimate frontiers sparknotes - How to cite jasp software - Opnet riverbed modeler - Date table 1 anion confirmation tests - What is the relationship between fica, erisa, and social security? - The power of five john c maxwell - Chapter 6 6 challenge problem accounting - How to play fidchell - How to write emotive language - Consumer needs - Assignment - 6 3 1 reflection assignment - Httprecipes login - Clean kitchen premises and equipment