Multi-Level Application Embedded into Site for Remote Access



To develop a web hosted database application that will serve the Organization's program in tracking client intake information and generate the required reports for operational management and grant funding. The application will be packaged to allow for multiple installations to be utilized by other similar Organization related organizations independent of each other yet accessed from a common web entry page.


The Organization's program collects demographic information from clients seeking financial and material assistance during difficult times through an intake process. Case workers must gather, and input into a computer database, personal information pertaining to members of the household, financial income and expense data as well as tracking other types of assistance the client currently receives in order to determine eligibility for assistance.

A date/time stamped diary of activity must also be maintained for archiving and logging the caseworker’s name that entered the information.

The design will incorporate screen tabs for each department rendering assistance to accommodate unique qualification criteria and track actual assistance provided by the Organization's program.

Basic Criteria:

1. The graphical user interface must be user friendly and designed for staff personnel who are not overly computer literate.

a. Page design should include tabs or link boxes for;

i. Client Profile

ii. Financial

iii. Food Pantry

iv. Assistance History

2. The web based application must be accessible to multiple subscribers simultaneously

a. It would desirable to prevent more than one subscriber from editing the same record as the same time

3. Data must be stored using SQL database

4. Username and Password Security Access

5. Ability to import existing MS Access database

6. Client Record search, edit and update capability

7. Reports

a. Selectable User defined fields to be included in the report

b. Ability to select date range

c. Certain types of data to auto calculate totals

d. A list of basic reports to be predesigned will be provided

8. Ability to define calculations of columns

i. Total families served

ii. Total individuals served (applicant plus members of household)

iii. Totals of age groups

1. # Adults (age 18 to 64)

2. # Elderly (age 65+)

3. # Children (under age 18)

iv. Totals by predefined income groups

b. Ability to create title for each report

c. Ability to save and archive reports generated based on subscribers option

i. Accessible only by administrative rights

d. Printable reports auto formatted to standard [url removed, login to view] paper size

e. Exportable to MS Excel

9. Administrator Portal

a. Password access

i. Restrict case workers to add/edit client records

b. Edit and Add pull-down lists content

c. Add/Edit/Delete users and passwords

d. Edit specific user-defined titles and fields (TBD)

10. Automatic Field Formatting

a. Date/Time

b. Telephone number

c. Social Security Number

11. Auto Calculations

a. Income Total

b. Expense Total

c. Expendable Income (Income less expenses)

d. Age of individual and dependents based on D.O.B. and current date of application

Maintenance and Updates

The quote should allow for up to 1 year of design modifications to ensure that the final application meets all of the program’s needs.


The designers must warrant that the application will function as specified and designed and make all necessary corrections in design or errors in programming.

Project Schedule:

Must provide an estimated time of project completion

This project will be government funded. 1/2 will be paid at the beginning of the project and 1/2 at completion.

modifying job type

Skills: SQL

See more: workers needs, website designers profile, web portal & application, web designers name, web designers list, web application quote, web application designers, using material design web site, unique web designers, types of programming errors, types of graphical design, types of data entry fields, types of data entry errors, types of computer programming, to level, title search report, time tracking project management, time track application, times standard, stored program computer

About the Employer:
( 6 reviews ) Concord, United States

Project ID: #607560

21 freelancers are bidding on average $21583 for this job


Please check PM for details, Regards...Frank

$3000 USD in 25 days
(1 Review)

Senior Programmer with 28 yrs. professional programming experience. Please view my PM.

$7500 USD in 60 days
(1 Review)

Hello. We can deliver and warrant this application to work as mentioned within one month. Please check PM for more. Thanks, Ziad

$5000 USD in 30 days
(0 Reviews)

Senior engineer/consultant with many years experience of software, web, database, application and system design and development. Please let me know if you are interested in so we can talk about details. Thanks!

$15000 USD in 60 days
(0 Reviews)

I am talented highly experience IT Professional who have executed various size project in different areas. First time in this portal I entered to make a good business relationship and to show my capabilities in the app More

$12500 USD in 50 days
(0 Reviews)

The bid includes one year of design modification from initial completion of 200 days. Roughly 1.5 years to complete satisfaction.

$225000 USD in 200 days
(0 Reviews)

I have been working in SQL for the past 5+yrs.. i assure i cna deliver the project within the timeline and with quality

$3500 USD in 10 days
(0 Reviews)

Hi, We are interested in this [login to view URL] provide you end to end solution for [login to view URL] provide you 3 months of warranty support on the final [login to view URL] reports and requirements should come to as a change o More

$6000 USD in 45 days
(0 Reviews)

Respect Sir/madam, i have 4 years experience in web appliation development.I can meet ur [login to view URL] check PM for demo application.

$30000 USD in 365 days
(0 Reviews)

We have coompleted at least 4 projects that have the same functionality as this project Please review our offerings at [login to view URL]

$17500 USD in 120 days
(0 Reviews)

Ready to start Pls check PMB for details Thanks Regards

$3437 USD in 72 days
(0 Reviews)

Dear Buyer, See PMB. -Sshram

$10500 USD in 365 days
(1 Review)

Hi, I have been working to these kind of projects for so much years. I am willing to do the job as soon as possible. Thanks.

$8000 USD in 6 days
(0 Reviews)

Please check pmb,thank you.

$50000 USD in 150 days
(0 Reviews)

as per discussed. inclusive on 1 year design work. Expecting to work with you. thanks and regards Raj

$5550 USD in 60 days
(0 Reviews)

Hi, We are Atlanta based Web Development Firm and interested in your project. we can offer a quality product with 100% [login to view URL] check your PMB for more details.

$6000 USD in 60 days
(0 Reviews)

Please check pmb thanks

$3200 USD in 330 days
(0 Reviews)

quality team from israel. please contact.

$7500 USD in 90 days
(0 Reviews)

Hi, I have been in Software Development business since 4 years and have successfully delivered projects for Nordstrom, GAP, Kraft, William-Sonoma. I have also been involved in the development of LMS for Baxter Interna More

$30000 USD in 180 days
(0 Reviews)

i can do what you want

$3000 USD in 90 days
(0 Reviews)