Đ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



**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 nhiều hơn: 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

ID dự án: #1068705

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


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

£170 GBP trong 5 ngày
(6 Nhận xét)

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

£75 GBP trong 5 ngày
(22 Nhận xét)

have a glance at Pm. Regards,

£250 GBP trong 6 ngày
(10 Nhận xét)

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ận xét)

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ận xét)

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ận xét)

I can do the project.

£250 GBP trong 15 ngày
(1 Nhận xét)

OK, Let's start to finish.

£100 GBP trong 5 ngày
(0 Nhận xét)

VB Expert here. Check PMB.

£200 GBP trong 4 ngày
(0 Nhận xét)

ready to take on the job. database drive application experience

£250 GBP trong 15 ngày
(0 Nhận xét)

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

£90 GBP trong 5 ngày
(0 Nhận xét)

sir i am a database expert, please check your PM

£150 GBP trong 4 ngày
(0 Nhận xét)

Sir, Plz see your pmb for more detail.

£240 GBP trong 20 ngày
(0 Nhận xét)