We help IT Professionals succeed at work.

Access VBA Training Material

siva_iaf
siva_iaf asked
on
Medium Priority
414 Views
Last Modified: 2013-11-29
Can anyone please send a good training material for learning Access VBA... to my Id..I am new to programming...

Regards
Sivakumar



Note: email addresses removed by modus_operandi.  Per EE rules, using email to answer a question is prohibited.
Comment
Watch Question

Author

Commented:
Also please suggest a Book for VBA Access ..quick reading ..(kindly dont suggest Access Developers Handbook..) as it is not available in market..
Any other book for beginners to learn quickly...

Regards
Siva
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
The best training material, in my opinion, is to review the code built by other developers. Access includes the Northwinds database, which has many good code samples, and there are many templates/samples on the Office website.

As far as books, the Mastering series has always been a good one. Search on "mastering access xxxx" where xxxx is the version you're using.

BTW: You shouldn't post your email in your postings, and it's against EE guidelines for you to use private email between members for this purpose. I've asked the mods to remove these. You can post them in your profile, of course, just don't do it in the message body.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks for the info.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
siva_iaf,

Most of the the Low-med level Access books will cover VBA Coding.

I can only learn things on a Need-to-know basis.
I never learned to do anything because it was the next lesson in a book.

If I need to do something I'll immediately Google it.
Read the code, make sure I can understand what the code is doing, then see if I can adapt it to work in my database.

IMHO, the best way to learn code is to, as LSM says, read the code of others.
There are litterally thousands of excellent example of VBA Coding right here on this site.

But the single best way to "Learn" coding is to write code.

As corny as it sounds, my college level Access and Database books were some of the best books I have.
Because they teach you a concept, the re-enforce it, then give you a similar task to do on your own.

Try to stay a way from the "Dummy's" or "Idiots", books.
Also avoid any book that claims to teach anything in "24 hours"

If you want the name and publisher of the college textbook, let me know.

Jeff
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
So why the B grade? You asked for training items, and Jeff and I provided you with practiced, standard answers. IMO, questions like this that get ANY answer really should be graded an A, since there is no right or wrong answer, only suggestions.

Author

Commented:
suggestions taken will keep in mind next time...
reg
Siva
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Thanks ... you might want to read over the EE guidelines regarding grading. It's not like grading in school:

http://www.experts-exchange.com/help.jsp

Click Answering Questions - What's the right grade to give.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.