Case Studies
Project Profile for the Salesman Database
Executive Summary
Company
The company based in Beecher, Illinois has been in business for over 30 years and is one of the fastest growing book distributors in the country.
Solution Description
The Salesman database provides all sales staff with a simple and effective method to find and order books that fit their customers’ needs.
Benefits
Sales staff can quickly find and compile a list of books that the customer needs to order. As a result, the program allows the sales staff to be more efficient leading to increasing customer satisfaction and sales.
Software and Services
- Microsoft Windows XP
- Microsoft Windows Vista
- Microsoft Access 2000
Customer Profile
Sector: Education
Industry: Educational Products
The book supplier is a full service resource for customers. The company offers thousands of books from major publishers along with many small, independent presses. The company provides their customers with in person one on one service along with the convenience of ordering products online.
Business Situation
Sales staff would visit their customers and would use a paper catalog to find books their customer would like. Searching for books in a paper catalog became time consuming and very difficult for new sales staff to memorize. Sometimes sales staff would miss opportunities to provide their customers with the books they need because they couldn’t find them in the catalog. The company needed to give the sales staff a system that would allow them to quickly search for books while visiting their customers. The system would also need to give sales staff the ability to enter customer orders and print them out.
Solution
The Salesman database provides sales staff with a simple method to search the complete book catalog using a number of different options to search on. The system enables the sales person to quickly give their customer a selection of books that matches their needs.
When books are found that the customer likes they can be added to the order. After the customer has found all the books they need, their order can be printed out.