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.

On Fri, 19 Jun 2009 11:35:01 -0700, Jill <(E-Mail Removed)>
wrote:

>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/acc...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).
--

John W. Vinson [MVP]

Allison Balters books are "bibles" by my desk.... :-)

"Jill" wrote:

> 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.

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.

"Jill" wrote:

> 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.

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)



"Jill" wrote:

> 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.