Looking for a good SQL Tutorial

[wcboyd]

Does anyone know of a good SQL tutorial for Access. I already have a decent understanding of SQL so what I am looking for is how to use SQL within Access. Any suggestions?

 

[shadow9449]

Hi, Craig

I found this to be useful:

http://msdn.microsoft.com/library/default.asp?url=/code/list/access.asp

There are 2 related articles. This one links to those. Check them out, and let us know how you fair.

Cheers,

SHADOW

 

[pono1]

The "Microsoft Jet SQL for Access 2000" papers (from Shadow's linked page) are good (if you don't mind me shadowing Shadow). If they're not quite what you had in mind, you may also want to download a few sample DBs from this forum in the Sample Databases section -- the DBs that deal with a combo- or listbox will often involve SQL strings. Also, if you have the time, browse through the Help file, searching on rowsource and recordsource, two properties that accept SQL strings. A good book can go a long way too -- the Access Developers Handbook is pricey but valuable if you think you will be using Access and VBA. There are other book recommendations scattered over these forums; I recall one post from Pat Hartman (one of the many Access mavens here) in which she listed at least a half dozen different titles, providing a one or two sentence description for each...

Regards,
Tim

 

[vengsiva]

This link is also worth a visit
http://www.fontstuff.com/access/acctut14.htm
vengsiva

 

[Mile-O]

This link is also worth a visit
http://www.fontstuff.com/access/acctut14.htm
vengsiva

To be honest, after reading some of his stuff in prior posts, I wouldn't listen to anything that guy says.