MS Access Trouble Shooting
For most companies, MS Access databases proliferate over the years and provide a fundamental cornerstone for decision making and running the operation. However, when a database is corrupted, for whatever reason, the usual recourse is to go to the last good backup. Andlau can facilitate that process or, where feasible, recover the data to the last position possible.
MS Access Maintenance and Deployment
MS Access database are usually located on an individual users PC and do not fall under any company wide security and recover policy. Andlau can help centralise all MS Access database, facilitate the deployment and version control for MS Access databases to reduce band width requirements on the network.
MS Access Analysis and Documentation
MS Access database due to their flexible and intuitive design faciltities tend to evolve rather than be derived from a structured design process. Therefore, over time, a lot of "black box" functionality can exist and the data design may not conform to good normalisation practices. Report writing becomes a black art and the systems do not necessarily deliver on their potential. Andlau can provide a structured review process that delivers comprehensive system documentation (functional and design) and a set of recommendations for the upgrade, if necessary, of those database. This would be a prerequiste for any migration project.
MS Access Migration to MS SQL Server
Today, the features and facilities of MS SQL Server are available and cost justifiable to all companies, from the smallest to the large enterprise. Implementation of MS SQL Server opens a huge myriad of opportunities in terms of delivery of information, security of information, and business intelligence solutions for the end users. Andlau can facilitate the migration process and also provide add on development to leverage on email, excel integration, reporting services, analysis services and sharepoint.