Sunday, August 2, 2009

To be able to learn ms access, do we have to learn visual basic as well?

i'm planning to take ms access course, but i don't know how to use visual basic, will it be ok? or i will have to learn both at the same time?

To be able to learn ms access, do we have to learn visual basic as well?
The short answers:


NO, You don't need to learn VB to learn MS ACCESS.


Yes, You will be OK learning JUST MS ACCESS.


It wouldn't HURT You to learn the scripting side at the same time, though you shouldn't need to (I havn't seen your course work, they may make You).





The long answer:


MS Access was designed for the novice user to learn quickly %26amp; begin using for basic development WITHOUT having to learn SQL (Standard Query Language - pronounced "sequel") or a scripting language (like VB). That's why it's so heavy in GUI (Graphical User Interface - Pictures instead of words).





A variation of VB (called VBA) is used for advanced scripting of MS ACCESS. There is enough difference between the 2 languages that there are different books about developing in VBA instead of VB.





I have seen pretty extensive DBs built without using ANY custom VBA code, since Acccess "MACROS" can be written through a "CGI" and they generate simple scripts in VBA for You.





Hope all this helps!
Reply:Visual basic is the underpinning of MS Access. If you want to be able to do anything remotely useful you'll have to learn it. SO, to answer your question directly. Yeah, learn it at the same time...
Reply:As you talked about VB and MS Access, I recommend you the following website





http://www.freetutes.com/VisualBasic


No comments:

Post a Comment