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.