Microsoft Access, a simple database warehouse to set up
February 19, 2018
Microsoft Access, a simple database warehouse to set up
Score 7 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft Access
The database is being used for a warehouse. It does some back-end calculations with table logic. Mostly a database warehouse of static data we can easily pull.
- Simple enough that you do not need to know SQL.
- Since Access is part of the Microsoft Suite, the functions are intuitive since we already use Excel extensive.
- The user interface is simple enough that people without database knowledge do not feel overwhelmed.
- I have trouble with printing issues. The format is not automatically done for you before printing.
- There may be a control issue. The back-end data if unlocked could be tampered with.
- The templates that are built in are not robust.
- Not as powerful as Oracle databases.
- Before we used Excel with macro, which became a huge file. Access is a true database with logic.
- Excel is less rigid but there is more room for error than Access.
- It satisfies our Sarbanes Oxley controls.
Microsoft is much more simple and far less powerful. However, that is often times all that is needed for the job. Essbase is better for large organizations that have multi business units that need to pull from the same datasource.