Computers And Technology High School

This problem continues Problem 8. Use the Access_Practice.accdb database that you have been working on to complete the following tasks.
a. Go to the Relationships screen and connect the five tables, enforcing referential integrity.
b. Calculate the total sales for each customer. Include CustomerID and CompanyName from the Customer table and the calculated sale amount from the Sale_Amount_Calculation query. Name the query Total_Customer_Sales.
c. Generate an e-mail user name for each employee using the first letter of the employee’s first name and the first five letters of the employee’s last name, e.g., Rod Smith = > rsmith. Include EmployeeID, EmployeeFirstName, and EmployeeLastName in the query. Name the query Employee_Email_Generator.
d. Calculate the total sales for each month.
e. Determine which customer had the highest average sales amount.
f. Assume the employees earn a 5 percent commission on sales. Calculate the total commission due to each employee. Use two queries to do these calculations.

Please provide Screenshots Thank You

Answers

Answer 1

To complete the tasks in the given problem, using the Access_Practice.accdb database, the following steps need to be taken: a) Connect the five tables in the Relationships screen and enforce referential integrity. b) Calculate the total sales for each customer by creating a query named Total_Customer_Sales, including CustomerID, CompanyName, and the calculated sale amount from the Sale_Amount_Calculation query.

To accomplish the tasks, open the Access_Practice.accdb database and navigate to the Relationships screen. Connect the five tables (Customer, Employee, Product, Sale, and Sale_Item) by establishing the appropriate relationships and enforcing referential integrity to maintain data consistency.

Next, create a query named Total_Customer_Sales to calculate the total sales for each customer. Include CustomerID and CompanyName from the Customer table and the calculated sale amount from the Sale_Amount_Calculation query. Run the query to display the results.

To generate an email username for each employee, create a query named Employee_Email_Generator. Use the first letter of the employee's first name and the first five letters of their last name to create the email username. Include EmployeeID, EmployeeFirstName, and EmployeeLastName in the query and run it to see the results.

To calculate the total sales for each month, create a query that groups the sales data by month and calculates the sum of sales for each month.

To determine which customer had the highest average sales amount, create a query that calculates the average sales amount for each customer and identifies the customer with the highest average.

Finally, create two queries to calculate the total commission due to each employee. Assume a 5 percent commission on sales and calculate the commission amount based on the employee's sales.

Take screenshots of the Relationships screen, the Total_Customer_Sales query, the Employee_Email_Generator query, and any other relevant queries to provide visual representation of the completed tasks.

Learn more about query here:

https://brainly.com/question/31663300

#SPJ11

Related Questions

Post a full paragraph consisting of 3 full sentences describing how to post CJE to GL. Please provide the following information for the step: - Describe what is involve in completing the step. For Clarity reason, state whether you are posting to the ledger using the T account format or 4column ledger format. Please be as specific and detail as possible as if you were teaching a friend on how to post. - Compare and contrast the difference you observe between posting JE vs AJE vs CJE to the GL. An example of what may be similar is that all JE, AJE, and CJE is posted to the same collection of ledger accounts. - If you understand the step well, please share what helps you get there or If you have difficulty understanding the step, please share what you use to overcome your initial difficulties. An example of what may help is that you read under the heading of "Closing Entries" in book and study Exhibit 4 in Chapter 4. - Comment on what happens to "Temporary" accounts once posting has been completed. The paragraph should contain at least 75 words.

Answers

Posting a Correcting Journal Entry (CJE) to the General Ledger (GL) involves carefully identifying the error in the initial entry, and then creating a new journal entry that corrects it.

For this description, we'll use the T-account format which is more visual and intuitive. The key difference between a regular JE (Journal Entry), an AJE (Adjusting Journal Entry), and a CJE is the purpose. A JE records daily transactions, an AJE updates account balances at the end of a period, and a CJE corrects an error in a previously recorded JE or AJE. To understand the process well, I often refer back to the "Correcting Entries" section in my textbook, paying close attention to examples. The most crucial part is identifying the error and understanding how to correct it. After posting a CJE, balances in temporary (or nominal) accounts like revenue, expense, and dividends accounts will reflect the corrected amounts. The balances in these accounts are then zeroed out (closed) at the end of the accounting period.

Learn more about CJE here:

https://brainly.com/question/32417045

#SPJ11

Other Questions
You work for a major consulting firm, and you just completed a team training on data backup strategies. Your manager has prepared a post-training assignment to test your team's knowledge after the training session. Label each of the following with the correct backup strategy: A. Full backup B. Differential backup C. Incremental backup 1. The backup strategy that copies all existing data every time: 2. A backup strategy used in the son backup cycle: 3. The cheapest data backup strategy, which uses the least amount of storage space: 4. The middle ground of backup strategies: 5. The data strategy used in the father backup cycle: Determine both the regular and overtime wage rates for each of the following employees. All are paid an overtime wage rate 1.5 times their respective regular wage rates.NOTE: For simplicity, all calculations throughout this exercise, both intermediate and final, should be rounded to two decimal places at each calculation.1:Alice Rhoades earns a weekly wage of $1,200. During the most recent week, she worked 48 hours.Regular Wage Rate = $Overtime Wage Rate = $2:Hank Long earns a biweekly wage of $3,400. During the most recent week, she worked 45 hours.Regular Wage Rate = $Overtime Wage Rate = $ Companies regularly review the locations where they offshore activities to and the associated costs. Some decide to reshore or nearshore. Referring to the world map at the start of the book, how do the various trends in offshoring impact the major logistics hubs in the world, and will there be a need for more and/or different hubs? In answering this it is a good idea to review some of the content of Chapter 2 on trends in globalization and international trade, and Chapters 6 and 7 on transport and containerization. The location of the various nodes depicted on the map is dictated by two factors viz. demand for transport to Ifrom those locations, and the hub and spoke nature of many transport networks. As we saw in earlier chapters, hub locations can be independent of local transport demand i.e. the hub location is dictated by overall network structure and not local transport demand. In reality, the global transport map is continuously evolving as transport demand changes - and of course we know that the latter is a derived demand so that in turn changes as the nature and location of both manufacturing and demand for products changes. So, what is the distinction between outsourcing and offshoring? Offshoring is not the same as outsourcing because outsourcing involves handing process ownership over to a third party, whereas with offshoring the company may still own and control the process itself in the lower cost location. It is also important to note that a company can if it wishes outsource and offshore a process at the same time. Furthermore, another important distinction we should make in the context of this module is between integration and collaboration. Supply chain integration is a term that embodies various communication channels and linkages within a supply chain network. Supply chain collaboration refers to how the relationship between supply chain partners develops over time. Integration is possible without collaboration. But if collaboration is required then integration is an enabler. Moreover, understanding the meaning of procurement as an 'umbrella term' that includes sourcing and purchasing and incorporates the activities involved in specifying requirements, identifying appropriate sources, evaluating options and then arranging the purchase of products and/or services from those sources that are fit for purpose, costeffective and sustainable is key. Procurement is thus concerned with more than just purchasing, with the latter in effect just a transactional activity. Finally, it is important for our well-rounded understanding of this module, to be able to describe and differentiate the various LSCM costing approaches and concepts. The following concepts are important in this context: - Opportunity costs - Landed costs - Activity-based costing - Total costs of ownership - Through / full life costs - Generalized costs What issues should a procurement manager for a large aerospace manufacturer with a global presence consider in appointing an LSP? qin a, musket a, musich pr, schweitzer jb, xie q. receptor tyrosine kinases as druggable targets in glioblastoma: do signaling pathways matters? Mariana has been hired to maintain the campaign website, social media accounts, blogs, and podcasts for a candidate for the u.s. senate. What is likely to be mariana's role in this political campaign? What can an individual do to further public health?A. Take vitaminsB. Go to the doctor regularlyC. Eat nutritious foodD. Take health education courses Write a letter to your friend telling him or her the importance of agriculture real measurements are adjusted for inflation. adjusted for inflation. fixed through time. fixed through time. increasing with prices. 1) Discuss an examplethat using creativity in decision making would help solve anorganizational problem.2) "The shareholders are the ownersof an organization; thus, it makes sense that the or State the null and alternative hypotheses for Amazons shoppingcart A/B test for Total Units Ordered (TUO), thenumber of items ordered. Give example of technological forecasting that have led, or may lead, to major disruption in the quality of relevant products or services in the given business sector. Explain the impact clearly in an A manufacturer has a production facility that requires 15,440 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 8 days. The unit purchase cost is $33.4 per unit. The cost to place and process an order from the supplier is $197 per order. The unit inventory carrying cost per year is 21 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. What is the reorder point for the manufacturer? Use at least 4 decimal places. 1. Every judicious organisation, even not-for-profit ones, must be primarily concerned with the health of the entity over the long run; the role of management thus becomes critical in charting the long-term goals of the establishment. Nevertheless, management is a function of many corollary activities such as planning, production, motivation etc. Discuss the roles of production/operations and culture in the determination of an organisations strategic plans. A(n) ________ is a chip that contains a large number of tiny transistors that are fabricated into a semiconducting material called silicon. A corporation issues a 14 years bond that pays \( 4.5 \% \) coupons at a price of \( \$ 1125 \). If the corporation can call the loan after 7 years at \( \$ 1050 \), find out its YTM and YTC, both in Yard Spray Inc. develops and produces spraying equipment for lawn maintenance and industrial uses. On January 31 of the current year, Yard 5 pray Ine. reacquired 15,100 shares of its common stock at $40 per share. On June 14,9,500 of the reacquired shares were soid at $43 per share, and on November 23,3,600 of the reacquired shares were sold at $46 a. Journalize the transactions of January 31, June 14. and November 23, If an amount box does not require an entry, leave it blank. b. What is the balance in Paideln Copital from Sale of Treasury Stock on December 31 of the current year? c. What is the balance in Treasury Stock on December 31 of the current year? d. How will the balance in Treasury stock be reported on the balance sheet? Retained Earnings Statement Pressure Pumps Corporation, a manufacturer of industrial pumps, reports the following results for the year ended January 31 , 20y2: Prepare a retained eamings statement for the fiscal year ended January 31,20Y. Blossom Corporation issued 1,200, $1,000 bonds at 103. Each bond was issued with one detachable stock warrant. After issuance, the bonds were sold separately at 97. The market price of the warrants without the bonds cannot be determined.Use the incremental method to record the issuance of the bonds and warrants "High pressure air __________, while low pressureair______________.'rises, sinkssinks, risesredistributes, stays in placecirculates counterclockwise, circulates clockwise With examples, list and describe 4 tips on how a salesperson can be an effective listener so they can clearly understand the customers needs 1.Analyze some basic performance indicators of BIDVMETLIFE2. Analyze bidvmetlife's swot 3. Some recommendations and asolutions to improve the current situation of bidvmetlife