Create a query that uses the following fields. Name the query with your name. CategoryName Discount...

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

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