VBA Learning Resources

[PSULionRP]

I am new to this job and will be doing some development in VBA through
Access.

Does anyone know of any good VBA courses online through Computer Based
Training so that I can get up to speed on the fundamentals of developing VBA
through Access quickly??? How about any books??? I understand and have most
of the fundamentals in Access, it's just that I have never divulged deeply
into the VBA Development world and am looking for some means to educate
myself and educate myself quickly and efficiently.

Any feedback is GREATLY appreciated and Thans in advance for your help.

PSULionRP

 

[Dale Fye]

You don't mention which version of Access you are using.

I still use my copy of the Acess 2000 Developers Handbook extensively. It
has lots of good code examples (including a companion CD with sample
databases for each chapter) and has two volumes (Desktop and Enterprise).
There are versions available for 2002 as well, but nothing more recent than
that.

Although there are a lot of changes between the 2000 and 2007 versions of
Access, the examples provided by Litwin, Getz, and Gilbert in these books are
great.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.

 

[Dorian]

Books are only one resource amony many to learn Access. They are better fro
reference than for learning. I would start by looking at the sample databases
and code. Then try to create a simple database yourself. VB syntax is simple
to learn if you know another programming language but it is the Access
commands and all their parameters that will take the time. You also need to
know SQL pretty well since so much development is creating queries.
The Access help screens are a vastly underutilized resource. And forums like
this can be a great help when you get stuck (as you will hundreds of times).
Type 'MS Access forum' into Google. This forum is only one of many. Ther are
also many many helpful websites. Use Google!
Don't expect to become an expert in Access quickly. I still learn something
new on each project and I've been using it heavily for 10 years.

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[dymondjack]

A good place to start for online tutorials would be

http://www.accessmvp.com/strive4peace/

This gives just about everything from the ground up.


As you get a comfortable with the basics and start wondering about specific
areas,

http://www.allenbrowne.com/tips

has some very useful information. There's tons of other online resources,
there's are only two that I know off the top of my head.



http://www.mvps.org/access/

This has a boatload of stuff as well, though much of it is aimed towards
more advanced projects. If you find yourself asking questions of the
newsgroups later on, you'll probably see this one a come up alot. Most
notable (IMO) are the APIs found in this site.


http://www.Lebans.com

Mr. Lebans has some very good stuff as well. A couple of my 'favorites'
have come from here.


http://www.smccall.demon.co.uk/
http://www.accessmvp.com/TWickerath/index.htm

I'm sure I left a lot of people out (many MVP's have their own pages for
tips/tricks etc), so sorry if I did, but aside from the books already
mentioned, these are some places I spent much time while learning the ropes.

hth

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill

 

[dymondjack]

Sorry Dorian... that was supposed to be a reply to the original post, not yours

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill