Book Recommendation

[Jill]

Hi all,

I learned Access early this year through two books since I got a new job in
sort of database management. It took less than a month for me to set up new
database and create bunch of queries, forms, reports. I do not have any
formal education in the computer field, and for my job, I do not need to
learn anything else because I have everything set up for my use now. But I
would like to learn more because I like what Access can do. Recently I began
to tackle VBA, and see it is a different animal. I read Dummies and Inside
Out, but I am not going anywhere yet. I learn stuff pretty well through
books. So I wonder if there are better books to learn VBA. I feel that there
are some very important information missing from both books. How did you
learn VBA? Can you recommend good basic books for a person like me?
Thank you.

 

[John W. Vinson]

Hi all,

I learned Access early this year through two books since I got a new job in
sort of database management. It took less than a month for me to set up new
database and create bunch of queries, forms, reports. I do not have any
formal education in the computer field, and for my job, I do not need to
learn anything else because I have everything set up for my use now. But I
would like to learn more because I like what Access can do. Recently I began
to tackle VBA, and see it is a different animal. I read Dummies and Inside
Out, but I am not going anywhere yet. I learn stuff pretty well through
books. So I wonder if there are better books to learn VBA. I feel that there
are some very important information missing from both books. How did you
learn VBA? Can you recommend good basic books for a person like me?
Thank you.

See the extensive book lists at Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

and The Access Web resources page:
http://www.mvps.org/access/resources/index.html

THE definitive book on *advanced* Access development (including extensive
hands-on VBA) is the formidable Access <version> Developer's Handbook by Getz
et al. They didn't publish a 2003 version but the 2000 or 2002 handbooks will
still cover most everything. It's a huge two-volume work, rather spendy... but
I've made up its price ten times over in the years I've used it (and I've got
the 2.0, 97 and 2000 editions).

 

[ThriftyFinanceGirl]

Allison Balters books are "bibles" by my desk....

 

[David H]

Sybex used to publish a book called the 'Access Developer's Bible', I haven't
seen any recent editions covering the newer versions of Access, but if you
can find one, I'd jump all over it. Even if its for an older version of
Access - even '97, the material is *EXCELLENT* and well worth it even if the
book doesn't cover functionality added in later version. It'll do a great job
in building a foundation.

 

[JimBurke via AccessMonster.com]

I would second the Getz, et al book. Lots of great stuff in that, but a lot
of it is a bit advanced. If you live near a Barnes and Noble or Borders, I'd
suggest taking a trip there and sitting down with some of their VBA books and
browsing through them a bit. Different authors have different approaches, and
some work for me and others don't. As with anything, one particular book may
be one person's bible and anothers garbage! The bookstores only have a subset
of what's available (lots online that you won't find there) but still there
should be a decent selection. Fortunately this place is here no matter what
and is an extremely valuable resource.

Hi all,

[quoted text clipped - 10 lines]

learn VBA? Can you recommend good basic books for a person like me?
Thank you.

See the extensive book lists at Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

and The Access Web resources page:
http://www.mvps.org/access/resources/index.html

THE definitive book on *advanced* Access development (including extensive
hands-on VBA) is the formidable Access <version> Developer's Handbook by Getz
et al. They didn't publish a 2003 version but the 2000 or 2002 handbooks will
still cover most everything. It's a huge two-volume work, rather spendy... but
I've made up its price ten times over in the years I've used it (and I've got
the 2.0, 97 and 2000 editions).

 

[Jack Leach]

Wrox Access 2003 VBA is what I used, and I would certainly recommend it.
Your situation is a mirror to what mine was when I started, and that book did
it for me (along with extensive subject specific internet searches and the
generous people that participate in these newsgroups).

That particular Wrox book covers just about everything you will ever need
from variables and scopes to classes and advanced error handling techniques.
Highly recommended. It is my access bible.

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)