October 1997
Intermediate to advanced
1312 pages
38h 56m
English
This chapter describes Structured Query Language (SQL), the structure and syntax of the language, and how Access translates queries you design with Access's graphical query-by-example (QBE) technique into SQL statements. A SQL background helps you understand the query process and design more efficient queries. Knowledge of SQL syntax is necessary to use the new sub-query and UNION query capabilities introduced by Access 2.0 and for many of the applications you write in Access VBA. Examples of SQL have been presented in other chapters in this book. These examples—usually figures that illustrate a SQL statement created by Access—demonstrate what occurs behind the scenes when you create a query ...
Read now
Unlock full access