Recommendations for books on SQL queries in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I pretty much just pick things up as needs arise but my use of Access is
becoming extensive and involved. Any recommendations for MS Access books in
general and specifically SQL queries.
 
Shawn said:
Any recommendations for MS Access books in
general and specifically SQL queries.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access SQL Book Recommendation 1
Recommendation to learn SQL for Ms Access. 1
Good morning 5
SQL Programming Book Recomendations 2
SQL Learning for novice 1
query links to SQL server and mdb table 1
Access 2010 append query to SQL is very slow 0
books on SQL 1

Back
Top