Shawn said:
Any recommendations for MS Access books in
general and specifically SQL queries.
For SQL it's probably best done the other way around i.e. learn
standard SQL then relate your knowledge to Access/Jet. You'll avoid bad
habits such as the noise of unnecessary of parentheses and brackets,
TOP N, procedural code, UDFs, etc. Jet SQL falls somewhat short of
entry level SQL-92 compliance but there are few showstoppers e.g. doing
an UPDATE the proper way with an EXISTS simply cannot be made to work
and you have to resort to the Access-only UPDATE syntax.
Free online SQL tutorials (e.g.
www.sqlcourse.com) are a good way to
start because you can try out your code as you go along using their SQL
interpreter.
