I'm loving SQL Cookbook by Molinaro (O'Reilly). The title explains it pretty well--it's like a cookbook full of recipes. Most of the recipes are for tasks that you would actually do in real life, which is refreshing. The book is categorized well and includes a nice mix of easy to hard SQL statements.
Unfortunately, the author did not include Access SQL in his examples, but almost all of the examples will work in Access because many of his solutions use the ANSI SQL standard.
Duluter