Answered step by step
Verified Expert Solution
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started