Transcript CertaPro Painters.pptx

• Gabriel Barbe
• Khashayar Karami
• Mariah Mekarski
• Linjie Su
• Michael Syracuse
Background of Project
CertaPro Painters
Professional Paint Contracting Franchise
1 Franchise =
Franchisee
Sales Associates
Hired Painters
Original company uses Lotus Notes
Sales Associates can’t see other associates without login info
Franchisee has to jump around to access all of the associates data
Some associates don’t use the database and just use paper, inconsistent
Our Database
created for 5 sample associates, not painters
Everyone can access all invoices, schedules, reports and data easily in one place
Business opportunity
Business value lies within the multiple reports and
accessibility of information
Reports extract and organize customer satisfaction data
Reports display estimate and job schedules, as well
incomplete jobs
Auto-generated invoices
Increases efficiency by eliminating the hassle of compiling
and analysing data
Database Design Overview
ERD
Simple Database Design
Brings flexibility and simplicity to the database
Contains all relevant information for the user
Different forms for all report reunited in a navigation form
User Interface Design
Built to be user friendly
Easy navigation through reports and forms
Assured data consistency (Input Masks and Validation
Rules)
Numerous macros and buttons to assure efficiency
Conditional formatting to highlight important information on
forms and reports
Low Maintenance System
Project Demonstration
Conclusion
The database conveys efficiency, accuracy and
saves time
It provides customizable report generating useful
niche information
It allocates jobs to employers and improve planning
for future jobs
End user friendly but powerful at the meantime
Questions