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
25 freelancers are bidding on average $148 for this job
Dear Sir, I'm Expert at access ,and interested on doing your [login to view URL] can check my prev work and my clients feedback. Kind Regards, NourElDeen