Learn SQL or Visual Basics??

[jomuir]

I have made a few db’s with tables, queries, forms and reports and I would say that my knowledge base is increasing, however most of my initial db’s use code that I have obtained online and that I have then altered/added to/enhance to work correctly with my solution. At times I have used a wee bit of SQL, Visual Basics and expression builder.

I am wanting to expand my knowledge base even more and I was thinking of looking into coding more with either SQL or Visual Basics, but not sure which one is the best to go forward with………..so thought I would ask you guys!!

I am about to start working with Crystal Reports too (a month or so, apparently) so I suppose if that uses one then that might be the best to learn.

 

[Tanner65]

I user Crystal Reports here at work before I started using MS Access and it seemed like Greek to me (I'm not Greek, fyi). So, I'd have to say that VB has helped me the most when using Crystal and MS Access. SQL is actually fairly simple, too me at least, but then again, I'm just now starting to learn it as well.

Jist, I'd say learn VBA first and SQL a very close second. If you can, learn them simultaneously.

A place where I've been looking at SQL a lot is 1keydata.com

 

[Tanner65]

>>> SQL is actually fairly simple <<<

In MS Access, it is fairly simple however once you start working with SQL server then the SQL language (I believe the one for MS SQL is transact SQL) is a language in its own right and can do some very powerful things within MS SQL server. I understand it is quite an art to turn MS Access functions into MS SQL server statements.

Well, like I said, I'm just beginning to learn it along with MS Access VBA (used VBS and Excel VBA, fairly extensively over the past 8 or so months) and the SQl statements I've seen are fairly simple if you don't let them get you overwhelmed.

Granted, you're right, I've only used MS SQL through Access, so my knowledge of SQL is extremely limited, but that's why we learn.