From the course: Access 2019: Queries
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Calculate sales price for a product line
From the course: Access 2019: Queries
Challenge: Calculate sales price for a product line
- [Narrator] In this challenge, I'd like you to apply a program flow function to the information about HPlus Sport's product line. Let's suppose that we're having an anniversary sale and all Rose and Teal colored products will be 25 percent off their regular retail price. All other products will be 10 percent off. Provide a calculated column that displays the pricing for all products during the sale. I estimate that this challenge should take about five minutes, good luck!
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.