WOT Security contacted Co-Development with a requirement for a system capable of importing Microsoft Excel templates returned by customers. The templates contain customer information relating to keys, locks and key codes.

After discussing the requirements with WOT Security, Co-Development began work on building a M icrosoft Access system which would import templetes returned by customers in Microsoft Excel format. Screens were designed and built which allowed the user to maintain customer and product information. Once written, further reports were added to allow WOT Security to analyze data. In total 5 screens were written which allowed addition, viewing and maintenance of data within the system. To maintain data integrity and allow usefull reporting where possible user input was selected from static “lookup” data withing dropdown lists.