r/programming • • 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

585 comments sorted by

View all comments

Show parent comments

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.

1

u/yopla May 08 '18

I think you have a very narrow vision of the world. Maybe you never had a real job where you had to balance a budget.

In the real world you have millions of people making the best of their limited resources and building apps and process tools in excel and access.

First they do not have the skills to use sql server and visual studio.

Second they dont have the budget to buy them and/or hire someone.

Third, so many of those apps dont even require the complexity of the infrastructure you're suggesting.

Do you think it make sense to use SQL server for a tool used by a secretary to manage a total of 100 invoices per year? You can do a full text search on 10 years worth of invoices without even needing to index anything and it'll still be fast.

That same secretary will be much better off with a less than perfect access tool over nothing because she can't afford your perfect architecture.

Sometime the inferior product is the best tool for the job.

1

u/therealcreamCHEESUS May 08 '18

One of the many cheap software packages for managing invoices and internal cashflow could be bought or a simple excel spreadsheet at that volume.

If its too complex for a spreadsheet then either get a software package or a proper database. If you go down the access route you are hindering yourself later on. If you are absolutely sure your business won't expand or your requirements and volume of data will never change significantly and know access well then maybe but few businesses operate on the principle of staying stagnent. You at the very least need to know DML concepts to design a decent access database anyway. You can struggle on without that knowledge but it will cost you later.

Thanks for your comments on my narrow vision, FYI my background is in reporting. I literally work in the industry you are saying I have a narrow vision of. Again if your business model is stagnent then go ahead but people like me get paid to sort out the situation a few years down the line after some inspired soul decides to hack together an access 'solution' round a core business process.

1

u/yopla May 08 '18

You've just repeated the same thing so just assume my answer is still about your limited understanding how how companies need to prioritize their capex spending and how small, intermediate, zero added cost, DIY solutions can provide a lot of benefit to a company.

→ More replies (5)