Appendix A. Review of Access SQL

IN THIS APPENDIX

An Introduction to SQL 342

SQL Structure and Syntax 348

Retrieving with SQL SELECT 350

Modifying with SQL UPDATE 354

Deleting with SQL DELETE 355

Appending With SQL INSERT INTO 355

Making Tables With SQL SELECT INTO 356

Creating a Crosstab Query with SQL TRANSFORM 357