From the course: Office 365: Access Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating a union query in SQL view

Creating a union query in SQL view - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

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…

Contents