Inventory tracking (about 50 items), invoicing (50 a month), customer data

Completed Posted Jun 17, 2014 Paid on delivery
Completed Paid on delivery

My business is: "Video equipment rental". My customers consult my catalogue on my website and then contact me through either phone or email.

How my business works:

1- When the customer contacts me, he makes a reservation for a few items that he will pick up on a given date, this is the rental order.

2- When customer comes to pick up the equipment he has reserved, the rental order is confirmed and becomes an invoice that updates inventory and customer dbase. (95% is paid with credit card so no need to track receivables)

To automate the whole process, I need:

1- A database with all equipment offered for rental with the different prices for the different periods of rental. With the desc of what will be written on the line item and the notices that will be written below the invoice laying out the costs if the item does not return or returns broken.

2- A customer database that will be completed as customer goes from inquiry to reservation to purchase. This dbase will keep track of what items a customer has ordered before, dates, notes about the customer etc ...

3- A rental order that will become an invoice.

4- A form to add the customer info to the database

5- A report that will tell me which customer has reserved what equipment, when the equipment will be picked up, when the equipment will be due back.

I will show you sketches of what I want the different forms and reports to look like, plus what fields are needed in the different tables

I want this to be written in a file format that can be opened with MS Access 2010

Microsoft Access

Project ID: #6082423

About the project

24 proposals Remote project Active Jun 24, 2014

Awarded to:

mail2vimalarora

Hi, I have gone through your full requirement as mentioned in description and feel comfortable in taking up the project. I have worked on several MS Access projects and can provide you database that will help you in More

$116 CAD in 3 days
(117 Reviews)
6.0

24 freelancers are bidding on average $152 for this job

jhaynes75

I have 15 years of experience as a software developer and consultant with specialties in programming and relational databases. I've worked for several employers through the freelancer website and have a proven reco More

$222 CAD in 5 days
(30 Reviews)
6.0
dipakmoliya

Dear Sir/Madam I have been in this industry for 6 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I More

$111 CAD in 3 days
(70 Reviews)
6.0
jawadaman

Hi, I am interested in this project. I can do this job for you. I am an experienced IT professional with hands-on experience of MS-Access database applications development. If interested in hiring me then please let m More

$111 CAD in 3 days
(77 Reviews)
5.7
farr4u

HI, Access and VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data opera More

$100 CAD in 5 days
(22 Reviews)
5.3
mrrapp

HI, I have been an Access consultant in New Jersey for the last 18 years. Access is all I do and I specialize in designing quick and efficient programs that are ready to be used as quickly as possible. My many h More

$155 CAD in 3 days
(6 Reviews)
4.7
abdellatif81

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft database More

$147 CAD in 8 days
(9 Reviews)
4.9
piyushdpatel

I have 8 yrs of Exp in VBA,VB6.0,VB.net and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Ready to start Can You send me your Sample sketch ? if you want i will also send demo of my work More

$150 CAD in 7 days
(12 Reviews)
4.8
sinfulm3

Hello Sir, I could fully developed this Video Equipment Rental database for you. I have similar project like this but it was a computer shop. I've fully understand your requirements and i'd like to add more feature More

$100 CAD in 5 days
(14 Reviews)
4.2
LearningNew

A proposal has not yet been provided

$210 CAD in 5 days
(5 Reviews)
3.9
acronymsolutions

Hi, I have gone through your descriptions,I understand it thoroughly,I am 5+ years experienced ASP.NET,VB.NET,MS Access,SQL Server developer at CMMI-5 level company.I can do your job easily before your deadline . Pleas More

$275 CAD in 7 days
(5 Reviews)
3.7
shallufreelancer

I know I don't have any review. but I can give u quality work. Please check my profile. My Completion rate is 100%

$105 CAD in 5 days
(2 Reviews)
3.0
Subburaj01

hi There, How are you ? i can finish this within 3 days time with good quality. Have done lot of access projects in the past. Please contact me to discuss further and ensure you hire the right person. My goa More

$115 CAD in 1 day
(1 Review)
2.6
nksundaram

Experienced software professional with 20 years in design, development and maintenance of applications

$194 CAD in 15 days
(2 Reviews)
1.8
swarm22

Dear Sir/Madam, I am freelancer. I have +4 year experiences in ms access database development. Able To Fulfill your all requirements. To Provide Quality , Modular , Professional Work. Give me contact information More

$155 CAD in 3 days
(3 Reviews)
2.0
garfchong

i can make you an online database system where you can manage, track and monitor all your inventory, customer, and so..... kindly consider. tq

$133 CAD in 5 days
(0 Reviews)
0.0
Pharoa

Thanks for the opportunity to bid on your project. I have read your tender and understand your requirements. I propose to develop and supply a solution using Ms Access 2007. I will bring over 20 years experience More

$155 CAD in 10 days
(0 Reviews)
2.4
spacesoftks

I'm very interested in this project and i have long experience as vb.net programmer. I have also created earlier this kind of applications.

$200 CAD in 3 days
(0 Reviews)
0.0
davidrudd

Your business application hosted on a production server within a week for just US$250. Spreadsheet ease-of-use plus accountability of a database and professional support. All changes recoverable from change history More

$250 CAD in 3 days
(0 Reviews)
0.0
nawazwasif

Dear Sir, my name is Muhammad Nawaz. I have the honour to bid on your project. I have read all the requirements of your project and assure you to provide what you needed. Please see my portfolio for previous work. Simp More

$111 CAD in 15 days
(0 Reviews)
0.0