Access - Great for Databases that don't come with a built-in report writer
August 30, 2017

Access - Great for Databases that don't come with a built-in report writer

Sam Sternman | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft Access

I use Access to track project timelines, record business expenses, and to manage our client database. For my clients, I use Access to build reports that are not currently built-in to the various Learning Management Systems (LMS) that I support - having the ability to locate records, find missing or inaccurate data, and run reports that combine various tables of information from the LMS' makes Access an invaluable resource for me.
  • Easy to navigate interface for building forms.
  • Easy to navigate switchboards for clients using the data on the front end.
  • Direct links to Excel, both importing and exporting data with ease.
  • The report writer could be more graphic, more Word-like.
  • The switchboard features could include design options to make the front end of the database look more professional and current.
  • Tutorials and how-to's could be improved and made more current (YouTube-like).
  • Makes it easy for me to keep track of deliverables.
  • Makes it easy for me to report Profit and Loss Statements.
  • Makes it easy for me to keep a customer relations database at my fingertips so that I can document calls, interactions, and projects under one database.
I hadn't considered other options - I used to use FileMaker (a long time ago) and since I'm no longer a Mac user, Access was a natural fit. I don't use, nor can I recommend a competitor product.
Access is great for those situations where you need to compare one set of data to another - helping you find matches, unmatched data, and allowing you to view chunks of data in a focused setting as needed. If you're missing a report writer for your own data or database, Access is a great option. The learning curve (in my opinion) isn't huge and you don't have to be a programmer to understand Access' visual approach to formulas.