Referral Tracking System
$30-100 USD
Pagado a la entrega
Referral Tracking System
1) Visual Basic 6
2) Must supply source code and rights included in price
3) 3 data entry screens (simple edits)
4) 1 navigation screen
5) 1 report request screen
6) .mdb database - 3 tables
7) 4 reports – (lists and counts)
Purpose: Store data on attendees and track and report on referrals.
Navigation: All windows inside a mdi window
Menu bar (please code)
Initial layout –
Title bar
Menu Bar
Navigation Window All Other Windows
Screens: Navigation window
Attendee’s data entry window (20 fields)
Attendance window ( 5 fields)
Referral window (4 fields)
Report Request Window
Tables: 1) Attendees (20 fields)
2) Referrals ( 5 fields)
3) Attendance (4 fields)
Reports: 1) Attendees List
2) Attendance List
2) Referrals by time period
3) Quarterly referral report
Navigation window
One line per window – on click opens window
Attendee’s data entry window / Attendees Table (text unless stated otherwise)
First Name (mandatory, text)
Last Name (mandatory, text)
Business Name (mandatory, text)
Addr Lin1
Addr Lin2
City
Prov
Pcode
Category
Description of activities
Business Phone
Fax
Cell
Other Phone
e-mail address
website address
reference 1
reference 2
application date (mandatory, date)
join date (mandatory, date)
Status (active / inactive - radio button)
Attendance window
Meeting Date
List of all active attendees
Attended (y/n)
Referral window
Date
Referee (drop down of active attendees)
Referrer (drop down of active attendees)
Desc Field
Attendance List Request Window
Date Range From
Date Range To
Referrals by time period
Date Range From
Date Range To
Quarterly Referral Report
Select year and Quarter
(Quarter 1 = Jan, Feb, Mar
Quarter 2 = Apr, May, Jun
etc)
Reports
Attendees list – (used to mark attendance)
Place to fill in the date
List active attendees down left hand side
Place to fill in attendance (present absent)
Ordered ascending by last name
Attendance List (used to report on attendance)
List attendee and number of meetings attended in time period
Select all (active and inactive) attendees
Ordered ascending ny last name
Referrals by time period
List attendee,
Referrals Received (number of times a referee)
Referrals Generated (number of times a referrer)
Ordered ascending by last name
Quarterly referral report
List Attendee
Number of times a referee
Number of times a referrer
(columns should be:
Name
Month 1 received (times a referee)
Month 1 generated (times a referrer)
Month 2 received (times a referee)
Month 2 generated (times a referrer)
Month 3 received (times a referee)
Month 3 generated (times a referrer))
Ordered ascending by last name
Nº del proyecto: #101816
Sobre el proyecto
Adjudicado a:
16 freelancers están ofertando un promedio de $69 por este trabajo
Dear Buyer, I have 7 years experience with VB6 and MS Access databases. The project you ask is fairly simple and I am really interested on working on it. Thanks in advance for considering my bid and I hope to hear fr Más
Good day, I represent the group of professional Russian programmers available to decide different tasks of any difficulty. Our group consists of practically all programming field specialists. We have very sufficient ex Más
Dear FrancisDavis34 , I would like to spend this moment to say thank you for spending your time in reading my bid. I will be happey to provide you my good experience in programming ,also you can see my profile. Más
I can do this for you. I have got 7+yrs exp software development. Loking for a favourable reply.
I have done MCA and have handled a lot of database projects like Stores inventory, Accounting package, Hospital Management. These were developed in VB, Delphi and Ms Access, SQL as the back End. quality is assured from Más