Microsoft Access
February 15, 2018

Microsoft Access

Nathan Duncan | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Access

Microsoft Access is used in our department for the reporting that we provide. Access is a great way for us to create a small database for our information. We then have created macros that make updating our reports and numbers very easy. Without Access this process would take much longer.

Pros

  • Access can hold a large amount of data and act as a data repository.
  • Access can create macros that allow you to quickly update your numbers.
  • Access is widely used across multiple companies and departments.

Cons

  • Access reports do have a size limit which will ultimately cause a problem for larger businesses.
  • SQL is used in Access and not everyone is familiar or able to write SQL.
  • Access is a snapshot in time and will not update without a manual effort.
  • Maintaining monthly reports is very easy.
  • Updates to the Access database require a SQL user to go in and update the code.
  • If an Access database does not work it is not obvious sometimes why that is.
  • OpenOffice and Glom
Access is used by a higher number of businesses, therefore, we continue to use it. Each of the alternatives has its own problems as well. Some are more SQL intensive, which make it undesirable.
Access has a lot of positives that have led to its wide use. The positives outweigh the negatives for most businesses. It lets users update and store a large amount of data relatively easily. The SQL requirement and data storage issue keep me from recommending it to everyone.

Comments

More Reviews of Microsoft Access