Question: Create a query that uses the following fields. Name the query with your name. CategoryName Discount ShippedDate Country (Customer Table) LastName (Employee Table) ProductName

Create a query that uses the following fields. Name the query with

Create a query that uses the following fields. Name the query with your name. CategoryName Discount ShippedDate Country (Customer Table) LastName (Employee Table) ProductName UnitPrice Quantity Rate Calculate a new field in above created query, name it Revenue = UnitPrice* (1-Discount) Quantity. Limit the query to records of orders shipped in 1998. Name your query 1998. From your 1998 query, answer the following questions. Write your answers in the blanks. Name each of following query starting from query 1, query 2, ..., query 5 and save them separately in your access file. How many orders in 1998 were made by customers in the USA? How many 1998 records generated revenue between $50 and $100? How many 1998 records were for Ikura orders? How many 1998 records were for Seafood orders shipped in April?

Step by Step Solution

★★★★★

3.41 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Im sorry but I am a textbased AI and cannot directly interact with or create queries in a specific d... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

Three blocks are in contact with each other on a frictionless, horizontal surface, as in Figure P5.54. A horizontal force F is applied to m1. Take m1 = 2.00 kg, m2 = 3.00 kg, m3 = 4.00 kg, and F =...

In the last chapter you modified some tables for the Wine Depot. Now Barbara would like you to help her create some queries to extract some information from the database. Make the following changes...

A child at the beach digs a hole in the sand and uses a pail to fill it with water having a mass of 1.20 kg. The mass of one molecule of water is 18.0 u. (a) Find the number of water molecules in...

The figure shows a bolted lap joint that uses SAE grade 8 bolts. The members are made of cold-drawn AISI 1040 steel. Find the safe tensile shear load F that can be applied to this connection if the...

Somatostatin is a tetradecapeptide of the hypothalamus that inhibits the release of pituitary growth hormone. Its amino acid sequence has been determined by a combination of Edman degradations and...

A spacecraft in the shape of a long cylinder has a length of 100 m, and its mass with occupants is 1 000 kg. It has strayed too close to a black hole having a mass 100 times that of the Sun (Fig....

Figure P31.42 represents an electromagnetic brake that uses eddy currents. An electromagnet hangs from a railroad car near one rail. To stop the car, a large current is sent through the coils of the...

A special promotion, consisting of 10 dozen novelty sweaters, is purchased at the cost of $240 per dozen. Determine the retail selling price of each sweater if the buyer wants a 52% markup.

What is the optimum pH to separate a mixture of lysine, arginine, and cysteine using electrophoresis? Draw the structures of the three amino acids in the protonation state that would predominate at...

Fein Company provided the following information relating to cash payments: Fein purchased direct materials on account in the following amounts: June $68,000 July 77,000 August 73,000 Fein pays 20% of...

Your friend Thomas, wants to start a new startup company. His idea is to create an app to rent personal cars. He says, this is going to be the Airbnb of car rental industry. He is really excited and...

You assist the controller of a newly established technology firm offering a pension plan to its employees. The company is considering going public in the next three years, and the president wants to...

XYZ, Inc had net sales in 2019 of 700,000. At December 31, 2019, before adjusting entries, the balances in selected accounts were: accounts receivable 125,000 debit, and allowance for doubtful...

On Jan 1, Aleksi Corp. purchased all outstanding shares of Sarrela Enterprises. The book value of Sarrelas assets and liabilities equaled their fair values except for apiece of land and a factory. On...

How does an effective leader clarify values by finding his/her voice, affirm these shared values, and set the example by aligning actions with shared values? An example is required from either how...

Why are list box controls used on a form?

Explain the difference between a worksheet and a workbook.

Describe how Excel can be used to calculate an allowance for uncollectible accounts using the percent of sales method.

The following table shows the mean annual percent return on capital (profitability) and the mean annual percentage sales growth for eight aerospace and defense companies. a. Compute the correlation...

Bardi Trucking Co., located in Cleveland, Ohio, makes deliveries in the Great Lakes region, the Southeast, and the Northeast. Jim Bardi, the president, is studying the relationship between the...

Below is information on the price per share and the dividend for a sample of 30 companies. a. Calculate the regression equation using selling price based on the annual dividend. b. Test the...