Project Summary
Many a times, the amount of data to be crunched is more than what excel can handle and it becomes imperative to look for a more comprehensive solution. If we are not looking to move to more advanced data handling solutions, then Access provides a good midway were Access can handle far more data as compared to excel and also provide the VBA based development environment. We have helped one of our clients with an automatic checklist generation routine which creates a reminder task for future dates based on the accounting activities. A reminder tool can then access such a table and generate automatic reminder mails on a future date hence ensuring that the client never misses an important task.
For even higher data storage levels, excel provides capabilities to integrate external sql database with excel. This allows the excel to behave as a front end tool similar to any web application with a central database and allowing multiple users to access the system at the same time.