Đang Thực Hiện

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

Kỹ năng: Microsoft Access

Xem thêm: access equipment rental, equipment rental access, access rental equipment, x-axis, rental c, rental a, company for microsoft installation, access equipment, s+db, in 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, access check check

Về Bên Thuê:
( 0 nhận xét ) Milan, Italy

Mã Dự Án: #1060831

Đã trao cho:

Nahsan

Please check PMB.

$120 USD trong 3 ngày
(0 Đánh Giá)
0.0
sandeep0734

I can do this please see my PM.

$51 USD trong 10 ngày
(0 Đánh Giá)
0.0

18 freelancer đang chào giá trung bình $123 cho công việc này

amnmttl

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

$100 USD trong 5 ngày
(15 Đánh Giá)
4.3
braghunath

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

$180 USD trong 10 ngày
(3 Đánh Giá)
4.1
PerfectSquare

please see the PM

$100 USD trong 5 ngày
(10 Đánh Giá)
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 trong 2 ngày
(1 Đánh Giá)
1.7
freeagent11

hi, please see PM. thanks.

$50 USD trong 3 ngày
(1 Đánh Giá)
1.3
bldroid

Experienced developer, please check PM.

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0
rmjudkins

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

$100 USD trong 2 ngày
(0 Đánh Giá)
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 Thêm

$150 USD trong 7 ngày
(0 Đánh Giá)
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 trong 15 ngày
(0 Đánh Giá)
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 [url removed, login to view] regards.

$90 USD trong 4 ngày
(0 Đánh Giá)
0.0
perryman

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

$150 USD trong 10 ngày
(0 Đánh Giá)
0.0
gacove

Please see PMB

$100 USD trong 3 ngày
(0 Đánh Giá)
0.0
mksanjeewa86

check my PM

$100 USD trong 5 ngày
(0 Đánh Giá)
0.0
MagikSystems

We specialize in easy to use custom access databases.

$105 USD trong 5 ngày
(0 Đánh Giá)
0.0
chndbdesign

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

$100 USD trong 5 ngày
(0 Đánh Giá)
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 Thêm

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0