Microsoft Access
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.
Pros
- 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.
Cons
- 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.
Comments
Please log in to join the conversation