Project Description: Brilton Madley, a board game manufacturer,

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

Struggling to find relevant content? Order a custom essay on
Project Description: Brilton Madley, a board game manufacturer,
Let our experts save you the hassle
Order Now
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
ENG 099
Excellent Paper. The only 100 in the class.
Customer 452775, July 19th, 2022
Human Resources Management (HRM)
Thanks for the prompt delvery.
Customer 452701, January 20th, 2023
Professions and Applied Sciences
Amazing work!
Customer 452707, May 29th, 2022
Social Work and Human Services
Excellent Work!
Customer 452587, August 24th, 2021
Marketing
Yes and thank you
Customer 452701, October 25th, 2022
Social Work and Human Services
Great Work!
Customer 452587, November 2nd, 2021
Other
GOOD
Customer 452813, July 5th, 2022
Nursing
I appreciate all the hard work. Thank you!
Customer 452525, August 13th, 2021
English 101
thank you
Customer 452483, February 27th, 2021
Finance
Thank You
Customer 452643, October 24th, 2021
Technology
I can work with it and massage it to what I need. Thank You
Customer 452827, July 19th, 2022
IT, Web
Don did an excellent job!!!
Customer 452885, January 25th, 2023
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
error: Content is protected !!

Save More. Score Better. Use coupon code SPECIAL for a 15%discount