I run an AV rental company and right now we keep track of the stuff going in and out with an excel sheet with days on the x-axis and the products (plasma screen 42" 1; plasma screen 42" 2; plasma screen 42" x; plasma screen 50" 1; plasma screen 50" 2; .....) on the y-axis, so that we know exactly if the equipment is or if it's out we know where it is (we write the name of the customer and the name of the exhibition where we will be installing the stuff in the cell).
We use another excel file for every exhibition to give to the technicians for the preparation of the equipments (the first sheet) and for the installation (the other sheets).
The first sheet is a list of the customer on the y-axis, the name of the products on the x-axis and the number of the specific product the customer wants in the cross cell.
The other sheets are one for each customer, automatically filled in with the name of the customer from sheet 1 and all the products he wants (always from sheet 1).
I now want to automate this process all in one in an access DB so that I just have to insert the name of the customer and what he wants and access has to automatically check if the products are available and create the 2 sheets mentioned before (for equipment preparation and for the installation).
I know I may have not been that clear...sorry about that, but I can provide, to who is interested, some examples for a better understanding.
Waiting for you.
18 freelancer đang chào giá trung bình $123 cho công việc này
Hi there, I do have a similar business and developed a tool to manage this and am very happy to share this application with you. My program has a strong reporting tool as well. Regards
Dear Manager, I have a long experience on Access 2003-2010. Please provide your requirements. I am capbale to finish your project in time. Thank you, Kazi
Hi,I would love to do this project for you. I specialise in systems analysis and database design & developement. I am sure your requirements cam be met in one system.Kind regards.