Overall Satisfaction with Microsoft Access
I was working with wind turbine data, it was massive 10 minute data with more than 20 columns per turbines. I was handling 4000+ turbines alone to analyze the failure rate and manage the analytical report which I need to extract from the 10 minute data. Excel can't manage large data, whereas Access helped to solve the data management of 4000+ turbines.
- Very flexible on making tables
- Data import is excellent
- Without having much programming knowledge, you can manage turbine data
- The forms required some more fancy work so that they match with recent days development from other software.
- It may be helpful if the farms are built through browsers like Python.
- Not sure about the revenue part, but I would say this almost saved weeks and weeks of my time. It also saved man power.
It's very compact and easy to access data.