Microsoft Access - Excellent tool for RAD but due for a significant overhaul.
Overall Satisfaction with Microsoft Access
- Imports data from almost every common data format. Custom import specification allows more flexibility.
- Excellent forms and report writer together query designer. Complete collection of tools in one place.
- VBA allows complex manipulation of data and automating it to cut down repetitive work.
- Data in MS Access can be linked directly with MS Excel, combing the powers of data management in MS Access and data visualisation in MS Excel.
- Overall capacity, such as file size (currently 2GB max) and the number of fields allowed (currently 255) needs to be increased.
- Needs significant enhancement to address file bloating issues.
- It's an excellent RAD tool. Haven't been overhauled in the last 10 years or so. It's about time that Microsoft commit more resources to this brilliant product
- Automating data through MS Access database has saved us heaps of times on a daily basis.
- Producing descriptive reports which virtually looks like a Word document has vastly improved our reporting capability and saved time.
- Linking MS Access with MS Excel has made it very easy to push data to end-users in an easy to manage spreadsheet style.
Do you think Microsoft Access delivers good value for the price?
Are you happy with Microsoft Access's feature set?
Did Microsoft Access live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of Microsoft Access go as expected?
Would you buy Microsoft Access again?
MS Access is excellent for setting up a small scale database or to simply import data and run VBA script to automate data manipulation tasks. It's also an excellent tool to link with enterprise-level data warehouses usually kept in Oracle or MS SQL Server. In such cases MS Access simple acts as a frontend tool that can query data. You can create professional reports for publishing data.
MS Access tends to fall short while handling bigger datasets that have more than a few million records. The processing time, especially when run from a network drive can be very slow compared to running on your local machine. The file size in such cases is also a limitation. Although that limitation can be overcome using multiple backend data files it does require a bit of routine maintenance.