Learning VB & VBA

[Julio626]

Can someone please direct me towards the right path to learning VBA or VB,
i've been working with Access 2003 for about 1 1/2 years and i know want to
expand my knowledge of VBA, i know there are several books out there in the
market ie Barnes n Noble, but it's hard to grasp the actual logic behind the
VB Language for me, what im looking for is either any schools or trade
programs anybody might now about or if microsoft offers courses on VBA or if
anybody has any recommendations on how they learned VBA/VB and can give me
some advice. Thank you very much.

 

[Lynn Trapp]

If there is a New Horizons Computer Learning Centers in your area, they offer
a class at a very basic level of VBA for Access.

 

[Larry Linson]

WROX has published several books on Access VBA for readers of different
levels of expertise. I know some of the authors and have read some of the
books... Google on "Access 2003 VBA" and "WROX". An excellent book on
Access itself, which includes some VBA information, is Access MVP John
Viescas' "Access 2003 Inside Out" published by Microsoft Press. MVP Crystal
Long has done some training videos which you can download free... a link is
included in the links to Access MVP's websites at my user group's Access SIG
Sharepoint Page, http://sp.ntpcug.org/accesssig/default.aspx. There are many
other good books, but I haven't looked at many in the past few years to make
recommendations on ones for Access 2003 VBA.

Good luck with the "major sources" of training. I did a search sometime
back, and few of those sources had updated their material since Access 2000.

As to how I learened: I was already conversant in BASIC in DOS and mainframe
days, learned about the separate Visual Basic product at my user group in
its V. 1 and V. 2 days... V. 3 included support for early Access databases.
But, at about the same time, Microsoft released the Access 1.0 product,
which caught my attention. With that background, following the
comp.databases.ms-access newsgroup and these Microsoft-sponsored newsgroups,
I was able to learn Access Basic from the manuals (yes, in the early days,
software did come with very good printed manuals), Access Basic was replaced
with the very similar VBA, and I can't even estimate how much I have spent
on Access books over the years -- but the best learning expeience has been
doing Access work for clients... there's nothing like a real-world
specification and a deadline to get you going and keep you going! Second
best learning experience has been preparing presentations for the majority
of meetings of the Access Special Interest Group in the North Texas PC User
Group since I started that SIG in April 1993.

Larry Linson
Microsoft Office Access MVP

 

[Julio626]

Thank you Lynn I will definately look into your suggestion. Thanks again

 

[Julio626]

Thank you Larry for your sound advice on my question i will definately look
into your suggestions and check out your website & the books you've
suggested. Thanks again.