A one-stop-shop for databases and reporting
April 30, 2019

A one-stop-shop for databases and reporting

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Access

Our team is involved in many asset management projects, particularly projects that deal with physical assets. We manage multiple databases and portfolio with single clients and Microsoft Access solves the problem of not being able to keep up and maintain all the databases at once. This program is used among the whole organization for a number of other projects as well.

Pros

  • No internet connection needed to make any database.
  • Importing into images, spreadsheets, & documents is easy.
  • Quick and easy tool to create databases, don't have to use SQL.
  • Great for storing large amounts of information.

Cons

  • Limited storage.
  • Wish there was a way that macros from Excel can be imported.
  • Loads a bit slow.
  • Can be time-consuming to learn; spending training hours.
  • Getting past certain hurdles that waste utilization time.
  • Creates some inefficiencies as it is slow once it handles a large amount of data.
Microsoft Access databases are more suitable for us because we are a smaller team. It's easy for us to export the reporting. It's also easy for people to create their own databases as well! Microsoft Access is honestly a one-stop-shop for us, and we figured we were not at a scale where MySQL was truly necessary.
It's a great program for certain house projects and can help automate workflow. It's great for repetitive tasks to be automated. It's great to use when your end deliverable to clients will be a physical report because it's easy to export it. We use it to conduct our analysis, and it's easy and quick to export a report!

Comments

More Reviews of Microsoft Access

  1. Home
  2. Relational Databases
  3. Microsoft Access Reviews
  4. User Review of Microsoft Access