Access is suitable for small organizations
June 21, 2018
Access is suitable for small organizations
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Access
We use MS Access for small data warehousing. Our data came from multiple sources. Access is included in our software set and it's an alternative to bigger database software. The software is used through our data departments.
- Data table preview, you can view the result data quickly for a relatively smaller result set.
- Great compatibility with Excel, import tables/queries to excel flawlessly.
- slow performance in a relatively large dataset.
- old Microsoft syntax for SQL language. Some basic syntax needs to be learned to write SQL in access.
- multiple users cannot work together at the same time in one database.
- Access still works great just like a local database. which do not require more money spent on DB software.
- Difficult to work together as a team at the same time due to lack of file sharing options of Access.
Access should be relatively cost effective because it is included in the MS office 365. But it is not suitable for larger organization due to lack of work sharing environment.