Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Difference between VBA and SQL

  • 30-01-2012 10:00am
    #1
    Registered Users, Registered Users 2 Posts: 1,154 ✭✭✭


    Im currently planning on training myself up on VBA. My current level of knowledge with it is that I have created dozens of macros for the reports in the company I work for using the Record Macro feature and am at a point where if necessary I can step into a macro and debug it or make minor amendments to it if its needed. However, I want to get to the point where I can create entire macros simply typing in code rather than using the Record tool or at least have the knowledge to do so.

    The job I do at the moment uses Excel a lot, but doesnt actually require me to use VBA or have any knowledge of VBA, everything Ive learned and am planning to learn will be on my own and in my personal time. Reason Im doing so is I want to upskill and expand my skillset, and good knowledge of VBA is something I see mentioned as being desirable by alot of employers.

    My first question is, what are the benefits to being able to type in code instead of using the Record tool to create macros? I imagine it would take far far longer doing out a whole macro via typed code? Is it more so because it looks impressive or attractive to potential employers that youre able to understand code like that, or are there greater benefits I dont know of?

    Second question is far broader... Im started on Access over the weekend (once again, something Im learning myself) and decided that I wanted to learn SQL after Im done with VBA. Im a bit confused though, I had thought VBA and SQL were basically the same thing. SQL is structured query language which was the term used to describe codes in programming and so on, so figured VBA is code, so its written in SQL, therefore, theyre the same thing. I spoke to someone in work who agreed with that, but then spoke to another work colleague who's excellent with VBA and he said theyre different, which lead me to believe something along the lines of "VBA applies to macros in Excel, SQL applies to macros in Access/database systems"... Ive tried finding answers on Google, but cant, could someone explain the difference to me?

    Thanks


Comments

  • Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭FSL


    VBA is a coding language that you can use to perform tasks in Microsoft Office Programmes.

    SQL is a language for manipulating Databases. There is an ANSI standard for SQL although database managers may contain additional functions.

    Becoming familiar with the syntax of a language does not make you a programmer. The same as learning say Italian will not make you a Poet.


Advertisement