Transcript Group Project PPT

West Herr in Williamsville
Customer Database
Team 4
Chan Su Kim,
Jiwook Lee,
Kevin Schmidt,
Willian Taiki Sueyasu,
Zhoungyuan Zheng
Background
● Kevin has a 2 years of Front line experience
at West Herr Chevrolet as a sales assistant.
● Sales associates used excel files to keep
track of their own customers sales.
Background
❏ It was a massive list going back almost 20
years for the sales associatate, Paul Mitchell.
❏ Each sales associate tracked the name of the
customer, address, phone number, vehicle
they sold, and how much they sold it for.
Business problem/opportunity
❏ But they were all autonomous on their own
computers and not sharing it.
❏ Kevin found that he would end up calling
the same customers twice in the same day.
Business Value
❏ Preserve the information that we’ve collected
from the customers.
❏ Classify those information and create
specific relationship to manage those
customer information efficiently
Database design overview
❏ Designed with ease of use for the managers
in mind.
❏ Easily input new data to the system with a
few clicks through the main menu.
❏ Output information in professional reports
User interface design
❏ We designed this database to be user friendly as
we are making it for managers and sales
associates who are unfamiliar with Access.
❏ To do this we made our switchboard designed as
a series of menus enabling the employees to use
the system without prior knowledge of Access.
Project demonstration
Conclusion
❏ Adds business value by allowing us to
increase our future revenues by leaving
good impressions with customers
❏ Takes paper out of the picture
❏ Simplifies an everyday process