Access VBA Training Material

Posted on 2009-02-17
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...


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

    Author Comment

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

    LVL 84

    Accepted Solution

    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.

    Author Comment

    Thanks for the info.
    LVL 74

    Assisted Solution

    by:Jeffrey Coachman

    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.

    LVL 84
    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 Comment

    suggestions taken will keep in mind next time...
    LVL 84
    Thanks ... you might want to read over the EE guidelines regarding grading. It's not like grading in school:

    Click Answering Questions - What's the right grade to give.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now