Access is core to our business
January 16, 2018
Access is core to our business
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Access
Microsoft Access is used by most of our organization. It is the back end of a medical billing application that our users access for reports, do input and export into other formats for sharing that data with providers and payers of medical billing. I directly access the databases to use data for complex reports that the application cannot provide and to repair the databases when there is a problem.
- For small databases it stores and handles the data well
- Exporting of data is easy and allows manipulation outside of the database
- Formatting of fields is easy as in most Microsoft Office applications
- The developer needs to watch how fields are formatted, poor design of a database leads to poor data
- Limitations to the amount of data able to be stored, if Access is tried to be used for things its not meant for, data corruption can occur
- Tools to manipulate the data while in the database could be improved
- We use Access daily and our application is fast and reliable, we get a lot of work done compared to similar web based applications
- Maintenance is needed on a regular basis, since our databases are used 24/7 this can be a challenge buy for most people this wouldn't be an issue.
- We continue to use Access as our go to product for the majority of our business, the application requires very little training to be competent
I find access easier to use than base or thunderbird but if you are familiar with Microsoft Office products, the learning curve is lessened by that. There is no comparision to SQL or MySql, but these are meant for larger more robust database applications. Access was actually in place when I started with this organization, but I had used Access at previous jobs and found it quick and easy to make small databases with input forms and reports for things that had been done manually before,