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