In Progress

Cafe Customer Database

Hi there,

Our company has around 50 major wholesale customers at present and we need to keep track of equipment at each site. The information includes whether the customer owns the equipment, or if we own if whether it is rented or on loan, the last time it was serviced (3 separate service criteria) and when the next service is due for each. This is based on the volume of coffee they use (e.g. one type of grinder the blades are good for 400kg, another type 600 etc). There is also info on the customer, whether they are on contract, when it expires, security regster code, plus the usual name/phone/address etc.

I have started to covert our excel file into a database. I have created 3 separate tables, one for customer info, one for grinder info and one for espresso machine info. Most of the info is now loaded in.

First I need someone to complete this database as I have hit a wall & run out of time. I need the tables to be properly related to one another. So that one customer can have more than one piece of equipment, but so that one piece of equipment can only be in one place at a time.

Second I then need a simple form created so that it is easy to enter a new cafe customer and their equipment which then updates all of the other tables automatically.

Third I then need a simple report that lists each piece of equipment that is due for servicing in the current month/next month and where it is (customer name, contact and address, phone).

The database should work on Access 2007 as this is what I have.

Skills: Excel, Microsoft Access, SQL, Visual Basic

See more: database customer cafe, cafe customer database, simple file database, simple contract service, service database access, customer service contact, customer it, covert file, contract service form, contract excel work, contract excel, service database , name coffee, loan servicing, database security, database info, coffee name, excel database visual basic, simple database visual basic, simple address database excel, simple contact database, loan equipment database, database track, track customers access, loan equipment

About the Employer:
( 7 reviews ) Auckland, New Zealand

Project ID: #1153912

Awarded to:

florinserban

Hi. Please check PM for details. Thanks!

$150 USD in 4 days
(15 Reviews)
4.3

53 freelancers are bidding on average $158 for this job

rhomeu

Advanced MS Access developer here. Please check my profile. Thanks!

$250 USD in 5 days
(41 Reviews)
6.5
jhaynes75

Professional software developer with over 11 years experience. Please see PM.

$200 USD in 7 days
(29 Reviews)
6.1
eperfections

CLEAR WITH REQUIREMENTS AND CAN DEVELOP THIS SYSTEM! Thanks ePerfections

$250 USD in 10 days
(89 Reviews)
6.1
mrbrave

See PMB for details...

$225 USD in 4 days
(79 Reviews)
5.4
tamrakar81

Hi , Please check PM . Thanks T

$200 USD in 30 days
(24 Reviews)
4.8
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly More

$100 USD in 1 day
(20 Reviews)
4.6
DamithaKD

Read pm sir :)

$200 USD in 10 days
(8 Reviews)
4.2
TCar

Hi, happy to help with this? Please see PM

$220 USD in 14 days
(6 Reviews)
4.2
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 in 10 days
(3 Reviews)
4.1
DeoTech

Hi! I have 7 years experience in Access. For example can do some test in [url removed, login to view] Regards.

$200 USD in 10 days
(6 Reviews)
4.1
guevanjr

Please consider my bid. Thanks,

$100 USD in 3 days
(8 Reviews)
3.5
Ratsclip

Let me help!

$200 USD in 3 days
(2 Reviews)
3.5
AccuPro

Please check PMB.

$125 USD in 5 days
(3 Reviews)
3.1
primasoft

Dear Sir, Please kindly refer to my PM for further detail Thank you Primasoft

$100 USD in 5 days
(6 Reviews)
3.0
irajghazanfar

Please see PM for details.

$100 USD in 5 days
(3 Reviews)
3.3
Swaroborno

Let's make a demo...

$150 USD in 7 days
(2 Reviews)
2.2
proitagent

Hi there, I am a ms access guru with over 14 years experience in application development and am sure I can help you in this. Regards

$125 USD in 2 days
(1 Review)
1.7
BGTServices

100% Satisfaction Guaranteed. Please See PM.

$200 USD in 3 days
(2 Reviews)
1.6
mbartone

I have extensive experience in MS Access. I can provide the base requirement database and provide additional functionality if needed.

$200 USD in 3 days
(0 Reviews)
0.0
rdennis125

I already have a solution that I can alter to meet your needs. It displays User information, equipment being serviced, when the specific equipment was serviced last (including parts used, service technician, and price More

$150 USD in 6 days
(0 Reviews)
0.0