SQL BOOKS 1

[jmandiaz]

Hi Guys,
do you guys have any recommendations for good ACCESS books or links with examples of SQL? Thanks in advance

 

[dhookom]

Check John Viescas' web site at

http://www.viescas.com.

He co-authored a book with Michael Hernandez that is one of the best.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[JeremyNYC]

As a reference, not a reading, don't forget about SQL Books Online.

---
Jeremy Wallace
METRIX Lead Developer
Fund for the City of New York
http:// metrix . fcny . org

 

[Knicks]

Dhookom,

Nice selection of books!

 

[dhookom]

SQL Books Online are very specific to SQL Server 2000 syntax. If jmandiaz wasn't kidding us when stating "good ACCESS books" then SQL BOL should be avoided. There are many features and syntax that are specific to either SQL Server or Access.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Knicks]

so is it your feeling that the SQL books mentioned at his website are not Access specific?

 

[dhookom]

The books on John's site vary. I had thought the SQL Queries for Mere Mortals was more focused on Access. Michael's book Database Design for Mere Mortals, Second Edition has been a standard.

For Access specific queries, I like "Access Database Design & Programming" by Steve Roman (O'Reilly)

http://www.bookpool.com/sm/0596002734.

My dog-eared copy is first edition from June 1997.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Pampers]

I think SQL BOL are specific for Trans-SQL used for the MS SQL Server 2000 (and 2005?). The SQL used in Access is refered to as JET-SQL if I'm not mistaking. If you program Access projects you will use Trans-SQL and the SQL BOL apply...

Pampers
You never too young to learn