Resources for intermediate user? (Access 2000)

[Martin Lacoste]

Wondering if people have suggestions as to good reference sources for
Access 2000 for an (almost..) intermediate user? It appears as
though books along the lines of 'Access for Dummies' are way too basic
for my needs. Or would I be best to continue to root around the
internet and this newsgroup? I really would like a book I can refer
to, however...

To give a better idea as to the level I'm looking at..
- queries are generally not a problem (though not terribly efficient,
I'd guess)
- macros - ok
- modules and VBA - have done a little here

But, and excuse my ignorance, I still have a heck of a time
differentiating between the various 'levels' of programming (ie. when
should one use a query vs. a macro vs. a module vs. VBA..etc..). I'd
like a resource that clearly defines and delineates the possibilities
and limits of each approach. Modules still confuse me in terms of how
they function within Access, and I even made some that worked!! A
clear and comprehensive resource that I can keep going back to when my
memory fades would be my wish!!

Any help is greatly appreciated!
Thanks!
Martin Lacoste

 

[Reggie]

Here are a couple of great places to start:
http://www.mvps.org/access/resources/books.htm
http://www.developershandbook.com/
http://www.lebans.com/
http://www.rogersaccesslibrary.com/index.htm
http://www.granite.ab.ca/accsmstr.htm
http://www.datastrat.com/
http://www.applecore99.com/frm/frm038.asp

Just to name a few. Most of these also have good links to check out.

 

[Guest]

I don't know how much difference there is between A2000 and A2003, but I found the A2003 Inside Out book to be suited to me - well laid out, not elementary in writing style, and very informative. If I ever forgot how to do a db app, I'd go to this book for a refresher. It also has a section that compares performing tasks via macro and via VBA - in most cases VBA seems the better choice. For VBA for Access I have several books including Developers Handbook set.

Books aside however, this ng has people posting how to questions all of the time. The answers posted by the experts are very useful and I've printed several threads that I thought might become useful later on too. Plus, I've tried solving some of the questions posted myself and that activity has reinforced and sharpened my Access skills. So even though I'm not working on a project right now, I'm improving through practice (use it or lose it?).

So my suggestion is continue 'rooting around the internet' AND find a book (books) you like.