Microsoft Access - Most Boring Review
February 20, 2018
Microsoft Access - Most Boring Review
Score 5 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Access
I know Microsoft Access is utilized specifically in my line of business. We had an external vendor create a front end and back end to create a data warehouse for us. This database warehouse includes specific liens so that we can input our customer's special characteristics and numbers.
It creates control, and also outputs information in an Excel format so that we can extrapolate the information in a reasonable manner.
It creates control, and also outputs information in an Excel format so that we can extrapolate the information in a reasonable manner.
- It is a true database (where it utilizes table logic)
- There are readily available templates
- It's part of the Microsoft Office Suite, so it's a bit more intuitive
- Database is not as robust than others in the space (Such as Oracle Essbase)
- Cannot utilize SQL
- If coding is not robust, output errors compiles
- Good database (data warehouse) where we are able to reliably maintain static data
- Cost of implementation was reasonable (cost wise)
- User Access in Front End Testing through User Access Testing was also reasonable (time wise)
The cost of Microsoft Access as a database was much less cost prohibitive than say other types of databases. Although not as robust as other databases (Oracle's suites such as Essbase), the cost, the time, the training and data integrity is fine for our line of business within a greater financial institution.