From the course: Access 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Creating a union query in SQL view
From the course: Access 2016 Essential Training
Creating a union query in SQL view
- The query design view is exceptionally powerful and it allows you to create a query for nearly any scenario that you can imagine. However, it really is just a front end to something even more powerful that's happening in the background. When you create a query in design view, Access is translating those instruction into code called structured query language, or SQL. You can see the code for the queries you've created by switching to this third view mode, SQL mode. Now I'm not going to be able to get into writing SQL queries here. There are other courses in the Lynda.com library that cover this topic in depth. But I thought it would be helpful for you to get just a taste of what this looks like. I want to walk you through the creation of one query type that you actually cannot create using the design view. The union query is useful for when you want to temporarily join two tables together. Unlike the append query, which permanently copies data from one table and saves it into…
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.
Contents
-
-
-
-
-
-
-
-
(Locked)
Using update queries6m 44s
-
(Locked)
Using make table queries3m 33s
-
(Locked)
Finding unmatched records4m 3s
-
(Locked)
Using delete queries4m 13s
-
(Locked)
Using append queries3m 50s
-
(Locked)
Creating a union query in SQL view5m 27s
-
(Locked)
Getting a different look with crosstab queries3m 19s
-
(Locked)
-
-
-
-
-
-
-