From the course: Access 2021: Queries
Join today to access over 25,300 courses taught by industry experts.
Challenge: Calculate sales price for a product line
From the course: Access 2021: Queries
Challenge: Calculate sales price for a product line
(upbeat music) - It's my opinion that the program flow functions are the most valuable functions available in Access. So for this challenge, I'd like you to apply a program flow function to the information about Red30 Tech's products line. Let's suppose that we're having a sale and we need a query to display the product prices with the pricing discounts applied. Our most popular products that have sold over 10,000 units will be 25% off their regular retail price. All other products will be 10% off provide a calculated column that displays the pricing for all products during the sale. I estimate that this challenge should take no more than about 10 minutes. Have fun.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.