15. Querying with SQL Statements


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

Get Business Solutions Microsoft® Office Access 2007 Forms, Reports, and Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.