Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

Im sorry but I am a textbased AI and cannot directly interact with or create queries in a specific d... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Microsoft Excel and Access 2016 for Accounting

Authors: Glenn Owen

5th edition

1337109048, 1337109045, 1337342149, 9781337342148 , 978-1337109048

More Books

Students also viewed these General Management questions

Question

Explain the importance of Human Resource Management

Answered: 1 week ago

Question

Discuss the scope of Human Resource Management

Answered: 1 week ago

Question

Discuss the different types of leadership

Answered: 1 week ago

Question

Write a note on Organisation manuals

Answered: 1 week ago

Question

Why are list box controls used on a form?

Answered: 1 week ago

Question

Explain the difference between a worksheet and a workbook.

Answered: 1 week ago