Special Edition Using Microsoft® Office Access 2003

Chapter 21. Moving from Jet Queries to Transact-SQL

In this chapter

• Understanding the Role of SQL in Access 2003

• Understanding SQL Grammar

• Writing SELECT Queries in SQL

• Writing Action Queries and Stored Procedures

• Working with Tables in Another Database

• Creating Tables with ANSI-92 DDL

• Using SQL Statements with Forms, Reports, and Controls

• Troubleshooting

• In the Real World—SQL as a Second Language

Understanding the Role of SQL in Access 2003

This chapter describes Structured Query Language (SQL), the grammar of the language, and SQL Server’s dialect of ANSI-92 SQL called Transact-SQL (T-SQL). Earlier chapters have demonstrated how Access translates queries you build in its Query Design view into Jet SQL statements. Jet SQL is another SQL dialect that closely ...