Customer: Primary School Supply Project: Label Management System Type: Windows Application

Primary School Supplies packages and distributes a collection of required school supplies based on classroom requirements. As a part of the package, customized labels with the students name, are provided that the student may affix to their gear for identification. Primary School Supplies receives listings in various formats, of the school, student name, grade, etc. Much manual effort was required to create the labels. They wanted an easy-to-use data entry screen that supports the efficient entry of manual lists of students. Additionally, they wanted an import mechanism that can perform bulk loads from student lists. Finally, they required additional reports to improve the distribution process.

ASI worked with Primary School Supplies to determine requirements for the new system. Once a specification was created and approved, ASI went to work. Microsoft Access was used and additional import/export functionality was added, integrating Microsoft Excel.

The data import and label creation and edit schemes substantially reduced the time required to process labels, while promoting consistent quality. The resulting application provided the necessary functionality, proved user-friendly, was flexible, and dependable. Tools: Microsoft Access, Microsoft Excel

Rob Mehne, Partner, Primary School Supply "Noel was good at understanding the design concept and requirements, and suggesting extended functionality. Things that come to mind, which I especially appreciate, include: flexibility of and control over output formatting, multi-user capability, and the maintainability and extendibility that comes with standard tools (Access). Overall, the project was a positive experience, and I plan to work with ASI again in the future."