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

Question

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?

Answer 1

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 & 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!

Answer 2

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

Answer 3

i do no longer think of a working hyperlink to an MS get right of entry to DB that enables custom soccer leagues exists. regardless of the undeniable fact that, you additionally could make one. you may create an MS get right of entry to DB and then define the ODBC connection on your Administrator ODBC connections. From there you need to layout the database. you need to have tables for group, gamers, Coaches, Drafts, participant information, customers, and communities etcs. then you certainly can create type merchandise of each of aforementioned tables. then you certainly ought to come to a call on the interface that human beings will use to hook up with this. it's going to in all probability be HTML, so which you need to come to a call on the Server which you rather choose to apply (ISS, Tomcat, and so on.) then you certainly will ought to determine the programming language and the motive force you will ought to apply. Then application the positioning. A framework like struts (that's a java answer) works o.k.. for my section, i take advantage of Java(JSP and Servlets) with Struts, Hibernate, and MySQL.

Answer 4

As you talked about VB and MS Access, I recommend you the following website



http://www.freetutes.com/VisualBasic