From the course: Access 2016: 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

Challenge: Convert US dollars to Canadian dollars

From the course: Access 2016: Queries

Start my 1-month free trial

Challenge: Convert US dollars to Canadian dollars

“

- [Voiceover] For challenge three, I'd like to apply what we just learned about mathematical operators and queries. Let's see if you can create a query that converts our product prices from US dollars to Canadian dollars. You'll need to do a little external 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. Good luck.

Contents