Intranet & Desktop accessible 'Control of Substances Hazardous to Health' System for manufacturing plant.
Vauxhall Motors approached ourselves as their preferred supplier of Database and Information systems to provide a central point for the employees across the entire site to access COSHH information.
The automotive manufacturing site has several buildings and blocks with specific manufacturing & processing within each area, so the information and substances vary. New suppliers are brought on and new modifications agreed weekly and monthly, so the system needs to be continuously updated and to manually administer the distribution of this key information continuously is unrealistic.
The requirement included desktop application & Intranet access of the information. We developed a full application using Microsoft Access as the desktop solution with Microsoft SQL server as the database engine. We employed & implemented a developer version of Microsoft Access resulting in hundreds of thousands of pounds being saved by the Company.
For the web based access we used Microsoft IIS server to host the website that we developed to gain access to the Microsoft SQL server with a later project seeing this upgrade to Microsoft SharePoint server.
Technologies used were: Microsoft SQL Server, Microsoft Windows Server, Microsoft Access, Microsoft Excel, Microsoft IIS, Microsoft SharePoint Server.