4 ms·
I work for a small finance firm. Before I joined everything was maintained ad-hoc in spreadsheets with no defined structure or consistency. I developed an Acces
by kqvamxurcagg 7y ago
I work for a small finance firm. Before I joined everything was maintained ad-hoc in spreadsheets with no defined structure or consistency. I developed an Access database that now acts as our data warehouse and reporting engine. We are talking here about tens of thousands of rows of data not millions. Access has forms that allow non-technical users easy access. SQL queries can run more complicated reports. Excel can also easily import Access queries and tables.
Programmers often don't understand that Excel and Access are valuable because you don't need a programmer, simply a professional with some technical knowledge. Developing a fully-fledged solution would slow you down and increase your developer headcount by 1. If any modifications need to be made you could waiting weeks for an IT/Developer team to react. IT often acts as a blocker for us trying to get work done with limited data sets.
There is nothing else quite like Access on the market. Air table is but a toy for those of us in business that need a serious tool that can integrate with Excel and has aggregate and SQL querying capabilities.