En cours

Access DB for equipment rental

Hi all,

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.

Regards,

Andrea

Compétences : Microsoft Access

Voir plus : access equipment rental, equipment rental access, access rental equipment, rental c, rental a, company microsoft installation, access equipment, process access, equipment, equipment rental, db, av, andrea, access microsoft, rental access, automate number, give exhibition, microsoft access check, excel list preparation, file access, products excel sheet, excel customer sheet, process sheet, excel sheet product list, cross check excel

Concernant l'employeur :
( 0 commentaires ) Milan, Italy

N° du projet : #1060831

Décerné à :

Nahsan

Please check PMB.

120 $ USD en 3 jours
(0 Commentaires)
0.0
sandeep0734

I can do this please see my PM.

51 $ USD en 10 jours
(0 Commentaires)
0.0

18 freelance ont fait une offre moyenne de 123 $ pour ce travail

amnmttl

Hello, Please check your PMB for bid details and demo video

100 $ USD en 5 jours
(15 Commentaires)
4.3
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks B.Raghunath

180 $ USD en 10 jours
(3 Commentaires)
4.1
PerfectSquare

please see the PM

100 $ USD en 5 jours
(10 Commentaires)
3.1
proitagent

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

200 $ USD en 2 jours
(1 Commentaire)
1.7
freeagent11

hi, please see PM. thanks.

50 $ USD en 3 jours
(1 Commentaire)
1.3
bldroid

Experienced developer, please check PM.

250 $ USD en 1 jour
(0 Commentaires)
0.0
rmjudkins

For the past decade my focus has been spreadsheet development within Excel utilizing VBA programming. Please refer to PM.

100 $ USD en 2 jours
(0 Commentaires)
0.0
TheRealQ

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

150 $ USD en 7 jours
(0 Commentaires)
0.0
bulaerashid

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

60 $ USD en 15 jours
(0 Commentaires)
0.0
patoh1199

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.

90 $ USD en 4 jours
(0 Commentaires)
0.0
perryman

Hi, Where's the excel file? Can you provide me with more information?

150 $ USD en 10 jours
(0 Commentaires)
0.0
gacove

Please see PMB

100 $ USD en 3 jours
(0 Commentaires)
0.0
mksanjeewa86

check my PM

100 $ USD en 5 jours
(0 Commentaires)
0.0
MagikSystems

We specialize in easy to use custom access databases.

105 $ USD en 5 jours
(0 Commentaires)
0.0
chndbdesign

I would love to work with you on this project. Thank you.

100 $ USD en 5 jours
(0 Commentaires)
0.0
ZhiZhang

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

200 $ USD en 10 jours
(0 Commentaires)
0.0