Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries

15. Querying with SQL Statements

IN THIS CHAPTER

Viewing the SQL Statement

Using SQL to Perform a Select Query

Using SQL to Perform Action Queries

Using SQL to Create Subqueries

Using SQL to Create Union Queries

From Here

When you build an Access query, what you’re really doing is building a Structured Query Language (SQL) statement. In other words, the Query Design view is just a front end to help you construct an SQL (pronounced ESS-kew-ell, although many people say it as SEE-kwul) statement without having to know anything about SQL syntax.

Fortunately, in a business context the majority of query needs are adequately fulfilled using the Design view (or even one of the query wizards), so business users don’t often need to learn SQL. However, ...