Microsoft Access and Excel?

Question

In Microsoft Access, it is possible to type in code as SQL.

Is there any code that can be used in Excel or is that not practical? I was just wondering what language I would have to learn to code for Excel. Maybe Visual Basic?

Also, what useful functions can I code for in Excel other than what comes with the software?

Is there some code in Excel similar to SQL in Access?

Thanks!

Answer 1

Excel comes with a special version of Visual Basic called Visual basic for Allpication (VBA), it is as powerful as Visual Basic.
So, if you know Visual Basic, then you can code in Excel with some background knowledge of Excel objects
I will recommand you (If you know VB) to start recording macros and play with generated code in VBA to see what is doing and learn VBA

This is the way I started to learn VBA in late 90s (I was good in QBasic at that time).

Enjoy my profile, I am the VBAXLMan

Answer 2

Access is a relational database; Excel is a spreadsheet. It is not true that Excel can do anything Access can do. There appear to be a lot of similarities and there is some overlap but how it's done is very different. Excel is good for crunching numbers, doing statistical analysis, etc. Access is for storing large numbers of records, like a 20,000 unit inventory. Excel would be used to analyze the sales and inventory levels of those units over a year's time.

Answer 3

Excel and Access both use Visual Basic (or variants thereof) for coding macros. With VB, you can code pretty well any function you want, as long as you have an algorithm for it.

Excel doesn't have SQL built in, but you can link Excel worksheets into Access and treat them as tables, and then run SQL queries agains them from Access.

Answer 4

Yes you can enter in SQL script in Access by changing to SQL View in Queries.

All Microsoft Office applications uses VBA for programming. It stand for Visual Basic for Applications.