Special Edition Using Microsoft® Access 2000

Chapter 23. Working with Structured Query Language

In this chapter

• Understanding the Role of SQL in Access 2000

• Using Access to Learn SQL

• Understanding SQL Grammar

• Writing SELECT Queries in SQL

• Using SQL Punctuation and Symbols

• Using SQL Statements to Create Access Queries

• Using the SQL Aggregate Functions

• Creating Joins with SQL

• Using UNION Queries

• Implementing Subqueries

• Writing Action and Crosstab Queries

• Adding IN to Use Tables in Another Database

• Comparing ANSI and Jet SQL

• Using SQL Statements in Forms, Reports, and Macros

• Troubleshooting

• In the Real World—SQL As a Second Language

Understanding the Role of SQL in Access 2000

This chapter describes Structured Query Language (SQL), the grammar of the language, and how Access translates queries you build in its ...