Simon Law has extensive experience in building software systems that integrate Excel and Access using VBA. The advantages of integrated solutions are outlined below.
Data entry and checking in Excel - Data storage and reporting from Access.
Many smaller business have data collection and reporting systems written in Access or some other microcomputer based database management system. Although these systems have great flexibility when it comes to reporting the data they contain, it is much more difficult to create efficient and flexible data entry forms to enter the raw data into the system. Poor data entry forms allow incorrect and spurious data to be entered into the system. The cost of developing efficient data entry forms that will maintain data integrity is often the majority of the cost of developing a reporting system.
Simon Law has an off-the-shelf product for rapid development of reporting systems. It has a data entry system built in Excel and an Access database system for automatically loading the data from the Excel workbook into Access data tables. Advantages of this system are:
Has written systems to load data and reports from a wide variety of systems, accounting and mapping, into Access and Excel for customised reporting and data analysis.