En cours

Customer Database With Product Rental and Picture storage

I need a basic database for handling customers and storage container rental. Very simple and basically the same as contact management demo database but with a few extras bolted on. Will be running it on Access 2010

Main tables (just example of what I think will be required)

----------------

Customers--->name,address,phone etc

Storage Containers-->container name,container description, monthly price,deposit price

Payment methods-->cash, cheque

Payment transactions--> for all bills and payments by custmer

Deposit transactions--> to store details of deposits paid and deposits refunded

Services--> list of services just incase we need to add bills for misc services

Features

------------

**View all customers form, with sort facility listing outstanding balance.

**Create new customer form

**Customer Manager feature so you can view the customers details, all storage containers rented. Price per month, and a list of all transactions for each month that passes and payments made by customer. ALso needs an area for transactions based on deposits paid and refunded. Customer Manager also needs to be able to store files, .doc .jpg related to that customer

**if storage container monthly prices are updated this should then update only the monthly rental fees for the next billing cycle

**it will auto generate the transactions, for example a customer rents a container on the 5th of jan for the first time, when you add the storage container to that customer it will gernate the first monthly bill and deposit, on the 5th Feb it will automatiocally generate the next monthly bill based on current rental price for that container.

**there will be approx 100 Storage containers available for rental, each will be of a certain type with default prices e.g

10ft container= £10per month , £20 Deposit

10ft container with compound = £15permonth, £25 deposit

these of course need to be editied and updated

>>Mock up image attached of edit/view customer window<<

Compétences : Microsoft Access

Voir plus : rental customers database, storage rental database access, the container store, services database, rental c, rental auto, rental a, product-manager, customer it, container store, containers c, c containers, cash store, billing microsoft, auto rents, auto rental services, auto rental prices, auto rental, access database services, container rental database, access 2010 container rental database, list of payment methods, description of product management, storage facility, rental description

Concernant l'employeur :
( 15 commentaires ) Rhuddlan, United Kingdom

N° du projet : #1068705

11 freelance ont fait une offre moyenne de 161 £ pour ce travail

instech

Hello Steve. Please see the PM for bid details, comments and suggestions.

170 £ GBP en 5 jours
(6 Commentaires)
4.6
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

75 £ GBP en 5 jours
(22 Commentaires)
4.3
shmai

have a glance at Pm. Regards,

250 £ GBP en 6 jours
(10 Commentaires)
4.0
ifaisal

Hello I can do this for you. Please see my private message for more details. Regards Faisal

150 £ GBP en 15 jours
(6 Commentaires)
3.7
aisha2010

Advanced MS Access developer from v.2003-2010 here. Please check private message box for more details. Thank you!

200 £ GBP en 2 jours
(2 Commentaires)
3.6
muthumuni

Hello Sir #####... Can you Kindly see PMB for details ...##### Your satisfaction is my success muthumuni (Gold member)

69 £ GBP en 2 jours
(1 Commentaire)
2.0
katjelko

I can do the project.

250 £ GBP en 15 jours
(1 Commentaire)
1.8
CreativeXperts

OK, Let's start to finish.

100 £ GBP en 5 jours
(0 Commentaires)
0.0
Nahsan

VB Expert here. Check PMB.

200 £ GBP en 4 jours
(0 Commentaires)
0.0
gerek69

ready to take on the job. database drive application experience

250 £ GBP en 15 jours
(0 Commentaires)
0.0
LuisGutierrez

More than 8 years of experience with MS access, ready to start your project

90 £ GBP en 5 jours
(0 Commentaires)
0.0
superMena2001

sir i am a database expert, please check your PM

150 £ GBP en 4 jours
(0 Commentaires)
0.0
muhammadibaad

Sir, Plz see your pmb for more detail.

240 £ GBP en 20 jours
(0 Commentaires)
0.0