Đang Thực Hiện

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<<

Kỹ năng: Microsoft Access

Xem thêm: 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

Về Bên Thuê:
( 15 nhận xét ) Rhuddlan, United Kingdom

Mã Dự Án: #1068705

11 freelancer đang chào giá trung bình £161 cho công việc này

instech

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

£170 GBP trong 5 ngày
(6 Đánh Giá)
4.6
KellogITSolution

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

£75 GBP trong 5 ngày
(22 Đánh Giá)
4.3
shmai

have a glance at Pm. Regards,

£250 GBP trong 6 ngày
(10 Đánh Giá)
4.0
ifaisal

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

£150 GBP trong 15 ngày
(6 Đánh Giá)
3.7
aisha2010

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

£200 GBP trong 2 ngày
(2 Đánh Giá)
3.6
muthumuni

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

£69 GBP trong 2 ngày
(1 Đánh Giá)
2.0
katjelko

I can do the project.

£250 GBP trong 15 ngày
(1 Đánh Giá)
1.8
CreativeXperts

OK, Let's start to finish.

£100 GBP trong 5 ngày
(0 Đánh Giá)
0.0
Nahsan

VB Expert here. Check PMB.

£200 GBP trong 4 ngày
(0 Đánh Giá)
0.0
gerek69

ready to take on the job. database drive application experience

£250 GBP trong 15 ngày
(0 Đánh Giá)
0.0
LuisGutierrez

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

£90 GBP trong 5 ngày
(0 Đánh Giá)
0.0
superMena2001

sir i am a database expert, please check your PM

£150 GBP trong 4 ngày
(0 Đánh Giá)
0.0
muhammadibaad

Sir, Plz see your pmb for more detail.

£240 GBP trong 20 ngày
(0 Đánh Giá)
0.0