1: Working with Jet SQL in the Access SQL window
2: Words reserved by SQL
3: The difference between ALL, DISTINCT, and DISTINCTROW
4: Retrieving only what you need
5: Variations in aggregates
6: GROUP BY considerations
7: Altering table structure
8: SQL’s problem child, INSERT INTO
9: Using UPDATE to delete values
10: Dropped properties with SELECT INTO
via techrepublic