Access is great for single person use.
January 29, 2018
Access is great for single person use.
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Access
Microsoft Access is used across our entire organization in order to provide unique databases for individual use. We have had success in using it as a front end for some very small SQL databases with limited users as well. It allows our users to start with a small database and then transition to a larger SQL server as needs warrant.
- Access is very easy to get started with and has some advanced features if necessary. Our customers enjoy the simplicity of getting started with Access.
- Front end creation is simple to create which facilitates data entry.
- Provides an introduction to relational databases without needing to know how to code in SQL.
- Frontend sharing needs developed. A workaround is required to make sure any changes to the frontend is pushed to the user.
- Coding functionality is non-intuitive and difficult to learn for most people. This area has not been improved for ages. This severely limits the user from providing more useful front ends.
- Access is very helpful as part of the overall Microsoft Office suite to provide our uses with a simple database tool.
- The limitations of Access are sometimes a helpful thing to central IT to drive more complex needs to a centralized solution.
FileMaker is much more robust for sharing amongst users. However, Microsoft has proven useful in its availability to our user base as well as helping drive complex needs to a centralized solution.