In this movie, Adam demonstrates his solution to the third challenge. After locating the current exchange rate between the U.S. Dollar and the Canadian Dollar, the query design process can proceed. A simple multiplication equation converts the US currency values into Canadian rates, and the column headers are cleaned up with aliases.
- [Voiceover] So were you able to create a…query that provided our product listing…in both US dollars and Canadian dollars?…Here's how I go about solving the problem.…First step is to figure out what…the current exchange rate is.…So I'll just go ahead and switch…over to Google real quick.…And we'll do a search here for…one USD in Canadian dollars.…And we can see that the current…exchange rate is one dollar is equal to…$1.28 in Canadian dollars.…Let's go ahead and go back in to Access…and we'll start creating our query in design view.…So we're gonna take our products table here,…and I'll add that in.…
Now I wanna add in a few fields.…I'm gonna add in the item name,…the size, the color, and the price.…In the next field I'm gonna right click…and go into my expression builder here.…Or I can go ahead and start building out…the function that is going to…multiply our current price times…the exchange rate.…Go ahead and find the products table.…Double click on price to add that up here,…and I'll just multiply that by 1.28.…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.