Microsoft® Office Access 2007 VBA

Appendix A. A Review of Access SQL

IN THIS APPENDIX

Introduction to SQL 373

SQL Structure and Syntax 374

The SELECT Statement 376

The INSERT Statement 380

The UPDATE Statement 382

The SELECT INTO Statement 382

The DELETE Statement 383

Crosstabs 383

Introduction to SQL

In addition to VBA, Access understands another computer language—Structured Query Language (SQL). SQL (pronounced sequel or S-Q-L) is the standard for working with relational databases, so it makes sense for Access to understand it. Although SQL is the standard, SQL itself has a number of dialects, each with its own keywords, syntax, and features. The dialect Access uses is, appropriately, called Access SQL. It follows the ANSI-SQL 92 standard pretty closely but does include some ...