Encerrado

Small Microsoft Access Project

We need to track our sales people's work, and below are the project requirements:

The application is to be developed in Microsoft Access. You are expected to use Access Tables to store data, Forms to present interface, and a few simple reports.

We have about 50 sales people, we need to keep track of each individual's sales record.

a. Let's say John Doe makes a $10,000 sale this month, his customer is expected to make payment of $6,000.

b. If the customer makes a payment less than $6,000, the sales person would be penalized; for example, if the customer only pays $4,000, the sales person would pay 10% of the difference, so it would be 20% * ($6,000 - $4,000) = $400. This penalty comes out of the sales person's monthly paycheck.

c. If the customer makes a payment greater than $6,000, the sales person would be rewarded; use above example, let's say customer pays $8,000, the sales person would be rewarded 20% * ($8,000 - $6,000) = $400. This reward would be included in the sales person's monthly paycheck.

d. Very importantly, above logic needs to be applied to each transaction. The reward and penalty is assessed every month, on each transaction. Whenever the customer makes a full payment for a transaction, that transaction is marked as Complete.

e. The interface should allow us to view and edit each sales person's transaction history, his rewards and penalties, the transaction history.

f. The report function should allow us to view transactions of different sales person for a specified date range.

g. The application should have the flexibility to change different variables, such as reward/penalty percentage, etc.

This is not a fancy or complex application, we are looking for a simple Microsoft Access application. Please bid accordingly.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

Microsoft Windows NT, 2000, Me, XP.

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: data access interface, xp project, transaction history, application microsoft access, access d, keep record access, access project program, sales report access, simple access example, windows program date change, customer reward, sales access, access form record, customer reward program, program monthly payment code, use code access, ready forms access, small windows application project, access report code, access reports php, small access project 2003, project done engineering, microsoft access complete project, expected deliverables project, simple access function

Acerca do Empregador:
( 18 comentários ) United States

ID do Projeto: #3020662

47 freelancers estão ofertando em média $86 para este trabalho

illuminesoft

See private message.

$38.25 USD in 4 dias
(361 Comentários)
7.7
tobsvw

See private message.

$63.75 USD in 4 dias
(67 Comentários)
6.0
creativexso

See private message.

$80.75 USD in 4 dias
(81 Comentários)
5.9
techzonevw

See private message.

$55.25 USD in 4 dias
(156 Comentários)
5.8
danvlas

See private message.

$63.75 USD in 4 dias
(75 Comentários)
5.6
edlukens

See private message.

$63.75 USD in 4 dias
(82 Comentários)
5.5
indiaguru

See private message.

$84.15 USD in 4 dias
(41 Comentários)
5.4
miguelgarcia78

See private message.

$51 USD in 4 dias
(79 Comentários)
5.2
expertbrain

See private message.

$46.75 USD in 4 dias
(53 Comentários)
5.1
prasanna123

See private message.

$85 USD in 4 dias
(58 Comentários)
5.1
yitzsl

See private message.

$212.5 USD in 4 dias
(7 Comentários)
4.6
alexpyrkov

See private message.

$41.65 USD in 4 dias
(16 Comentários)
4.5
zdcodinginc

See private message.

$55.25 USD in 4 dias
(24 Comentários)
4.5
saadrahmanvw

See private message.

$25.5 USD in 4 dias
(23 Comentários)
4.4
itsoftvw

See private message.

$68 USD in 4 dias
(16 Comentários)
3.8
techjunc

See private message.

$68 USD in 4 dias
(21 Comentários)
3.6
kkruse66

See private message.

$85 USD in 4 dias
(4 Comentários)
3.5
ppiluk

See private message.

$21.25 USD in 4 dias
(1 Comentário)
3.3
bapanghosh

See private message.

$153 USD in 4 dias
(6 Comentários)
3.4
bigursusvw

See private message.

$42.5 USD in 4 dias
(12 Comentários)
2.9