Solid product for most average database users
May 23, 2019

Solid product for most average database users

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

Overall Satisfaction with Microsoft Access

We currently use Microsoft Access as a front end to some of our databases that are in other formats and link the tables. This allows us to create queries and reports in a simple interface that many of our staff can use with some training and once the ODBC connections have been set up. There are times when we want to cross-reference data between different data sources, and Access allows us the ability to link/import multiple sources to achieve our analysis goals.

We also currently use Access throughout the workforce when there are specific departmental needs for collecting data.
  • Links to existing data sources
  • Allows for importing of data from different data sources
  • Lets you create queries and reports without having to know proprietary database syntax
  • For the average user, better assistance with table relations
  • Some sort of prompt when creating reports and queries that they should be based off of queries as to provide more flexibility rather than from tables
  • More advanced reporting tools
  • Not having to recreate queries or reports every time you want to use them.
  • Once an item is created and saved as part of the database, you save manpower by not having to recreate them.
  • ROI from a usability standpoint is great. Solid product with great functionality that requires low maintenance usually.
FileMaker Pro focuses more on data collection in a single, flat file while Access allows for relationships to be drawn between data tables the reduces duplication. I have not worked with FileMaker Pro for several years but found it to be very unwieldy for my needs which were mostly relational.
Microsoft Access is best suited as a front end to other databases as well as for small to medium databases where the user determines that they have gone beyond the design and function capabilities of Excel. Microsoft Access is less suited when there is a need for heavy database use and complex data queries. All in all, for the average Office user who needs a database program, Access is a solid choice.