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: Convert US dollars to Canadian dollars
From the course: Access 2019: Queries
Challenge: Convert US dollars to Canadian dollars
- [Instructor] For challenge three, I'd like to apply what we just learned about using mathematical operators and queries. Let's see if we can create a query that converts our product prices from US dollars to Canadian dollars. You'll need to do a little extra on research to find out what the current exchange rate is. But once you have that figure in hand, it should be a straightforward procedure. Make sure you clean up the query results in order to make them presentable. This challenge should take less than five minutes to complete.
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.