Access is great for single person use.
January 29, 2018

Access is great for single person use.

Stephen Swan | TrustRadius Reviewer
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.

Pros

  • 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.

Cons

  • 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.
Well suited for single person use for simple databases.
Unsuited for shared databases or front end use.

Comments

More Reviews of Microsoft Access