r/programming • u/[deleted] • May 08 '18
Excel adds JavaScript support
https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel
2.4k
Upvotes
2
u/therealcreamCHEESUS May 08 '18
No but you have visual studio for building front ends.
Access is a database for non database people.
If you really need to be able to manipulate data either master excel or learn a proper DML like T-SQL.
With SQL you can have much larger database sizes, variables, more than 255 users, full joins, count distinct etc etc. So many features in SQL don't exist in access.
There is a very good reason why Access is not that well supported, its an inferior product for people who do not have the technical skills to properly manage data.
Sure its easier, cheaper and has a much shallower learning curve but if your doing anything important, you should do it properly or get a DB developer to do it properly. You will save yourself money and time in the long run.