What are the best Learning reasorces for Access or books available? [Archive]

Zrob

11-26-2009, 06:42 PM

I am totally new to Access and the SQL world but I need to start learning this, what would you recommend for books or web resources?

OBP

11-28-2009, 04:50 AM

I have used the following books, you can probably get Access 2007 versions of them.

"Beginning Access 2000 VBA"
by Robert Smith & David Sussman
(ISBN 0-7645-4383-0)

Microsoft Access 2000 Bible
> by Cary N Prague and Michael R Irwin
> ISBN0-7645-3404-1
> Published by IDG Books.
>
> Mastering Access 2000
> by Alan Simpson and Celeste Robinson
> ISBN 0-7821-2326-0
> Published by Sybex

For more complex VBA the Forums have a wealth of answers.
For most Access development I offer a free one to one help, but my SQL is not very good.

Zrob

11-28-2009, 02:21 PM

I have used the following books, you can probably get Access 2007 versions of them.

"Beginning Access 2000 VBA"
by Robert Smith & David Sussman
(ISBN 0-7645-4383-0)

Microsoft Access 2000 Bible
> by Cary N Prague and Michael R Irwin
> ISBN0-7645-3404-1
> Published by IDG Books.
>
> Mastering Access 2000
> by Alan Simpson and Celeste Robinson
> ISBN 0-7821-2326-0
> Published by Sybex

For more complex VBA the Forums have a wealth of answers.
For most Access development I offer a free one to one help, but my SQL is not very good.

Thanks for the info on the books!

So do you use VBA in access to manipulate data & reports instead of SQL; SQL is used in access correct??

OBP

11-29-2009, 03:19 AM

Zrob, I only use VBA recordsets or VBA SQL if ordinary Queries (SQL) don't do then job.
The Access Query Wizard takes care of the Simpler SQL aspects of creating queries.

CreganTur

12-02-2009, 09:00 AM

Access 2007: Programming By Example With VBA, XML, and ASP is one of the best books I've read for VBA. You have to work through all of the code examples to get anything out of it, though.

After you've worked through it and have a handle on VBA- if you have been bitten by the programming bug and want to check out something else I cannot reccommend Head First C# enough- it is the best programming book I have ever read. Period. I finally understand classes because of this book.

Zrob

12-02-2009, 04:28 PM

Access 2007:.....After you've worked through it and have a handle on VBA- if you have been bitten by the programming bug and want to check out something else I cannot reccommend Head First C# enough- it is the best programming book I have ever read. Period. I finally understand classes because of this book.

Cool, I been doing a lot of VB.net w/classes BUT I wanted to learn some C# also!

Thanks.