Bulk Data Processing

Integrating Access and Excel for Processing Large Volumes of Data

It is not uncommon even for small businesses to have to manage sizeable quantities of data. As businesses grow, complexity is likely to increase as well as the amount of information to be processed. A good data model will speed up processing.

Some businesses have significantly large volumes of data to process. Programmed correctly, the tools available on your desktop are likely to be all you need to achieve this.

Spreadsheet applications such as Excel provide excellent analytical tools for routine and ad-hoc analysis, and can indeed store and compute large amounts of data. However, spreadsheets have their limitations. Analysis is far more meaningful when results can be compared with other information. Yet it is hard to maintain the relational aspect of information when it is stored in spreadsheets.

Accuracy is essential if meaningful conclusions are to be drawn or decisions made. Since it is harder to validate spreadsheet data, the accuracy and integrity can be improved by integrating with other software.

The most efficient solution is to use a relational database such as Access to record and store information. Bulk data manipulation can be handled within this software, without the need to resort to expensive data warehousing applications. Where required simple import/export facilities will make it easy for regular or ad hoc processing using spreadsheet tools.

Project Examples...

Excel Export with Access Version Control

Excel integration with Access was needed for the manipulation of large data sets. Our client also required improved version control to manage the distribution of his Genstat Market Size Databases to customers running different versions of Access.

Project example for Excel Export + Access Version Control

Processing large amounts of information and website integration

Our client is a market leading manufacturer of innovative products designed to serve the central heating sector. ADEY Professional Heating Solutions were experiencing problems with their Access database when importing large amounts of data collected from their website, and trying to process this information.

Project example for Web Import + Volume Data Processing

Problem Solving Missing Data and Export for Print-Run

We rewrote the database for this animal charity, so they are now able to find and pass on information to their supporters. We also provided an export facility of all relevant information for their brochure print runs, considerably reducing the time it had previously taken to collate this information.

Project example for Problem Solving and Export for Print-Run

Microsoft Access integration with Word and Excel for Contact Management System

A marketing company required custom Contact Management software to help them manage an expanding range of services provided to the UK veterinary sector. They needed to integrate a Microsoft Access database with Word and Excel and to automate a number of regular processes.

Project example for Contact Management with Office Integration

Management Information System for a Marketing Department

A call centre for an international financial company had very specific requirements for both data capture and reporting. They needed a flexible system that would adapt to rapidly changing requirements. We developed a Management Information System for their call centre which significantly improved staff efficiency and provided comprehensive relevant reporting.

Project example for Call Centre Information System