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 freelance font une offre moyenne de $123 pour ce travail
I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [login to view URL]
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
For the past decade my focus has been spreadsheet development within Excel utilizing VBA programming. Please refer to PM.
I have built databases and spreadsheets as a daily part of my job for over 10 years. This would be a great use of Access and I know I can produce a tool that will significantly improve your business process. One of m Plus
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 [login to view URL] regards.
hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f Plus