Add fields and create a few reports

완료 등록 시간: Jul 9, 2008 착불
완료 착불

This is what I need:

1) Add 4 fields to a database, include them in a form.

2) Create 3 simple reports, and make them accesible from the switchboard.

3) Fix 2 reports that do not work.

*****Fields needed**

a) Prospect Pipeline

1) Not contacted

2) Initial contact

3) Sample sent

4) Negotiating sale

5) Active customer

b) CP case potential for season

1) 0-100

2) 100-250

3) 250-500

4) 500-1000

5) 1,000+

c) Annual Potential per year

1) $0-1K

2) $1-10K

3) $10-50K

4) $50-100K

5) $100K+

d) Initial Contact made by

1) Daniel Alfaro

2) Jim Booman

3) Jake Rudnick

4) Rafael Villanueva

These fields need to be placed in the main form (the one that is accessed by the MAIN SWITCHBOARD under Enter/View contact).

I guess the default value should be 'Not available' for all 4 *new fields*

***** Reports needed**

Create reports to sort database by

a) Annual potential per year

b) CP case potential for season

c) Prospect pipeline

These reports need to be accessed from the switchboard and be place under PREVIEW REPORTS

**

*** Reports to be fixed**

Also, please fix the 2 existing reports, it asks for work.extension.

See database attached.

THANKS!

## Deliverables

Database attached

공학 마이크로소프트 마이크로소프트 엑세스 MySQL PHP 프로젝트 관리 소프트웨어 아키텍처 소프트웨어 테스팅 앱을 위한 비주얼 베이직 윈도우 데스크탑

프로젝트 ID: #3040559

프로젝트 소개

2 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: Jul 9, 2008

수상자:

ashishbharti

See private message.

$25.5 USD (21일 이내)
(9건의 리뷰)
2.1

이 일자리에 대한 프리랜서 2 명의 평균 입찰가: $119

vnoutsourcingvw

See private message.

$212.5 USD (21일 이내)
(47 리뷰)
4.7