Create additional select queries for What SUP using computed fields. (Use the Ch11-02 student file, or use
Question:
Create additional select queries for What SUP using computed fields. (Use the Ch11-02 student file, or use the file you used in answering the previous question.)
a. Create and print a select query that lists the product name unit price, unit cost, and unit gross profit for all products. Sorted in descending order by unit gross profit price. (Hint:You’ll need to create a computed field titled Unit Gross Profit whose formula is the product’s unit price minus unit cost.) Save this query as Ch 11 Assignment 5a before you print it.
b. Create and print a select query that lists the product name, unit price, quantity, and sales value for all paddles. Sort the query by unit price in ascending order. Save this query as Ch 11 Assignment 5b before you print it.
Step by Step Answer:
Using Microsoft Excel and Access 2016 for Accounting
ISBN: 978-1337109048
5th edition
Authors: Glenn Owen