Upgrading from Excel to Access and Relational Databases
Has your business expanded beyond the limits of Excel?
Spreadsheets are widely used by small and emerging businesses to store their data, and can be used effectively to solve "simple" database problems. However scope for scalability is limited. As demand for products or services increases, and client requirements evolve, businesses often struggle to keep pace.
A relational database will give you so much more….. We will save you time by automating many routine jobs, as well as simplifying time-consuming or complex tasks. With forms and reports specific to your business, you will maintain far greater control over your business.
If you prefer you can continue to use spreadsheets for specific tasks such as financial analysis, as we can link this seamlessly with your new database to maximise the benefits of both.
Expert System and Excel spreadsheet to Access conversion
ADEY Professional Heating Solutions, specialist manufacturer of central heating products, had an existing Expert System that they needed to extend to record additional information, improve validation, as well as incorporate historical data. This was achieved by converting their existing Excel based system to a Microsoft Access database, with a custom Visual Basic module
Project example for Excel to Access for an Expert System
PDA Hardware Integration with Access database
A business which supplies retail outlets with farm produce was finding it difficult to keep pace with increasing demand for their products as well as the greater flexibility required by their clients. Moving from a manual rounds system to a computerised one, using a ruggadized PDA integrating with an order processing system, has significantly reduced the administrative workload, and made it far easier to handle ad hoc changes to deliveries.
Project example for Integrate PDA with Access + Invoicing
Invoicing with Sage integration, Job Management with SMS messaging application
inRode is a custom built Job Management System, handling the allocation of deliveries to drivers. It incorporates a bespoke invoicing system to help them manage industry specific billing requirements, with electronic transfer of information for integration with Sage. The most recent addition was an integrated CMS application for automatically sending text messages to drivers with delivery information.
Project example for Auto Text Messaging and Job Management
Work Flow System with Billing and ISO 9001 Compliance Support
We developed a new custom Access database when rapid expansion of our client's business made it difficult for him to keep pace with invoicing. The new custom built Work Flow System combines job management, accurate billing, as well as ISO 9001 compliance.
Project example for Work Flow System + ISO 9001 Support