Articles

 Industry:   Industrial Manufacturing      Language:   Visual Basic for Applications       Database:   Microsoft Access/Excel/Outlook     Application Type:   MSDS Inventory System 


 Project Decription:  

Our challenge in this project was the adaptation of data base functionality to inventory tracking of chemical products sold by multiple chemical productin and shipping companies.

PCG was approached by this client wanting a "turn key" product to sell to their customers, who anticipated an inventory tracking application designed to match, select, and include the manandatory, Material Data Safety Sheets which accompanied each of the chemicals transported to which the correct componentssafety labels customization required for shipping potnetially hazadous material.s had approachedbecause This database is a turnkey product that Compliance Consulting Services sells. It was designed to track the inventory of companies that ship chemical products around the US. Each chemical must have a Material Data Saftey Sheet attached to it and a proper marker/sticker/sign that reflects how the chemical is to be eliminated or neutralized dependent upon the type of spill (ie; oil goes into a river, how do you fix it). This database printed thermal labels to allow the company to produce the proper labels to affix to packages. Additionally, location and inventory control of the stock levels of the chemicals was written into this database to facilitate location of all products at any given time to insure compliance with OSHA

 

Project Components: 

  • Technical Specification
  • Scope Analysis
  • Design Model
  • Data Conversion
  • Implementation
  • Integration Testing
  • Training