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

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 Solution

3.52 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a b Product Name Sleeping One Candice Appleby Zoomer Glide GS Nalu Badfish 2 Veneer Raven N... View full answer

blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1512_605d88e15f72b_680060.pdf

180 KBs PDF File

Word file Icon

1512_605d88e15f72b_680060.docx

120 KBs Word File

Students Have Also Explored These Related Using Microsoft Excel Questions!