Overall Satisfaction with Microsoft Access
Microsoft Access is used in our department for the reporting that we provide. Access is a great way for us to create a small database for our information. We then have created macros that make updating our reports and numbers very easy. Without Access this process would take much longer.
- Access can hold a large amount of data and act as a data repository.
- Access can create macros that allow you to quickly update your numbers.
- Access is widely used across multiple companies and departments.
- Access reports do have a size limit which will ultimately cause a problem for larger businesses.
- SQL is used in Access and not everyone is familiar or able to write SQL.
- Access is a snapshot in time and will not update without a manual effort.
- Maintaining monthly reports is very easy.
- Updates to the Access database require a SQL user to go in and update the code.
- If an Access database does not work it is not obvious sometimes why that is.
- OpenOffice and Glom
Access is used by a higher number of businesses, therefore, we continue to use it. Each of the alternatives has its own problems as well. Some are more SQL intensive, which make it undesirable.