Business solutions Automating Microsoft

A. Review of Access SQL

IN THIS APPENDIX

An Introduction to SQL

SQL Structure and Syntax

Retrieving with SQL SELECT

Modifying with SQL UPDATE

Deleting with SQL DELETE

Appending With SQL INSERT INTO

Making Tables With SQL SELECT INTO

Creating a Crosstab Query with SQL TRANSFORM

An Introduction to SQL

VBA isn’t the only language Access understands. Structured Query Language (SQL) is the de facto language of relational databases, and as such, Access also speaks SQL. Specifically, Access speaks a dialect known as Jet SQL. Although you’ll often hear Jet SQL called Access SQL, SQL speaks to Jet, not Access. This appendix covers general information about Jet SQL as well as syntax instructions and a short language reference. This short appendix ...