Microsoft® Access 2003 Forms, Reports and Queries

Chapter 6. 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 166

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, there ...