Best Access book for beginner

[crobaseball]

Hello,

I'm fairly Excel savvy and gen tech savvy and am looking for a solid Access "manual" to go through. I have "The Missing Manual" O'Reilly puts out and am not happy. I used their version of Excel ages ago, and it was solid, but the one from Access has had some errors/refers to some things prev which it says it explained but didn't.

Anyone who is now a mid-range Access person who started with a book they look back on and think it did a good job?

Thanks!

 

[Redwolfx]

Not a book, but this is where I started, it helped a lot

SQL Tutorial

 

[bgrove]

Not a book, but this is where I started, it helped a lot

SQL Tutorial

crobaseball The website that Redwolfx posted is a good start but the SQL does not transfer directly over to MSACCESS SQL. MSACCESS is JET-SQL and what is on the website is for SQL Server or T-SQL.

I'm would actually love a book that provides syntax and examples for JET-SQL as well as VBA that works just with MSACCESS. I cannot find any books. I use the MSACCESS forums but it is very slow learning and can get frustrating because any response you get on your question is not complete or provides enough detail.

If you find something please let me know. Thanks

 

[xenou]

IMHO you can get a whole lot out of just two books:

Learn to use Access:
Microsoft Access 2003 Forms, Reports, and Queries by Paul McFredries

Learn to program Access VBA:
Automating Microsoft Access with VBA by Gunderloy and Harkins



This assumes you know SQL If you don't know SQL, get a SQL book too. There are many good ones. For a "wordy" introduction that lives up to its name (explains a lot in laymen's terms) you can try SQL For Mere Mortals and/or Database Design for Mere Mortals, both by Michael Hernandez. A more concise treatment is in Teach Yourself SQL in 10 Minutes by Ben Forta, and a more classical text is Learning SQL by Beaulieu.


My knowledge of Access is out of date, though - I'm basically an Access 2003 developer (though I happen to use Access 2007 in actual fact). I haven't found any reason to get excited about the latest features in Access 2010 and 2013, at least not yet.

 

[alansidman]

Here are two sites I like to recommend for Access starters.

http://sbuweb.tcu.edu/bjones/20263/Access/AC101_FundamentalsDB_Design.pdf

and

Access Basics

 

[crobaseball]

crobaseball The website that Redwolfx posted is a good start but the SQL does not transfer directly over to MSACCESS SQL. MSACCESS is JET-SQL and what is on the website is for SQL Server or T-SQL.

I'm would actually love a book that provides syntax and examples for JET-SQL as well as VBA that works just with MSACCESS. I cannot find any books. I use the MSACCESS forums but it is very slow learning and can get frustrating because any response you get on your question is not complete or provides enough detail.

If you find something please let me know. Thanks

I'll look. As mentioned in my post, I have something which is intro Access, with intro VBA. And it's ok. The same author did the Excel manual, and it's much better.

 

[crobaseball]

Here are two sites I like to recommend for Access starters.

http://sbuweb.tcu.edu/bjones/20263/Access/AC101_FundamentalsDB_Design.pdf

and

Access Basics

ty!!

 

[crobaseball]

IMHO you can get a whole lot out of just two books:

Learn to use Access:
Microsoft Access 2003 Forms, Reports, and Queries by Paul McFredries

Learn to program Access VBA:
Automating Microsoft Access with VBA by Gunderloy and Harkins



This assumes you know SQL If you don't know SQL, get a SQL book too. There are many good ones. For a "wordy" introduction that lives up to its name (explains a lot in laymen's terms) you can try SQL For Mere Mortals and/or Database Design for Mere Mortals, both by Michael Hernandez. A more concise treatment is in Teach Yourself SQL in 10 Minutes by Ben Forta, and a more classical text is Learning SQL by Beaulieu.


My knowledge of Access is out of date, though - I'm basically an Access 2003 developer (though I happen to use Access 2007 in actual fact). I haven't found any reason to get excited about the latest features in Access 2010 and 2013, at least not yet.

I'll take a look at them. ty!!!

 

[james_lankford]

crobaseball The website that Redwolfx posted is a good start but the SQL does not transfer directly over to MSACCESS SQL. MSACCESS is JET-SQL and what is on the website is for SQL Server or T-SQL.

I'm would actually love a book that provides syntax and examples for JET-SQL as well as VBA that works just with MSACCESS. I cannot find any books. I use the MSACCESS forums but it is very slow learning and can get frustrating because any response you get on your question is not complete or provides enough detail.

If you find something please let me know. Thanks

99% of the sql in that tutorial will work just fine in Access
even the "create index" section
and where there are differences the site is pretty good about pointing them out --- see the section on autoincrement
SQL AUTO INCREMENT a Field