Kitchens by Design Inventory Order System

Jeffery Ayers

April 2004

Walt Turner

 

Background

 

Having family in the construction business, I have had the chance to spend most of my summers, and any extra time, working in that industry.? I do spend a good bit of that time running around picking up and dropping off material for projects.? During this time, I met the owners of Kitchens by Design and watched how they tracked their inventory.? I asked them if I could create a system that would allow them to use their time more productively.?

 

Project Description

 

The database has several tables that either hold static data or dynamic data.? The static data is used to populate list and combo boxes.? The dynamic data is used to link customer, manufacturer and cabinet information to an order.? This allows the user, who has limited computer knowledge, to create a better way of tracking and checking their inventory.? The reports that Visual Basic creates are complemented by Excel Spreadsheets that are created from data in the database.? This allows them to check the order coming off the truck, with what they ordered for a particular job.? I have utilized the tool tip function in Visual Basic to help with any learning curve needed to learn this program.

 

Conclusion

 

This project has taught me to access information needed to complete this project in a limited time frame.? I also learned that I can create a complex program, interact with customers, ask the right questions, and learn what the customer needs verses what they want.? The classes that were most useful are CSCI 342, 446, 343 and 346.