Access Database (2003 or 2007) required to record maintenance activities on an industrial site for a service contractor.
These activities are based upon a piece of equipment, and are to be completed at specific intervals eg: daily, monthly, every 5000 hours etc.
An example of a daily activity could be: Record the temperature of the diesel generator motor on a daily basis.
A report is generated every day with the list of activities that needs to be done, and on what piece of equipment it has to be done on.
I will include a flat-file of data to the successful bidder that can be used. I have included an example row of data for you all to view. I have also included the functionality required in a text file.
There is a possibility that this database will grow in functionality ... including the possibility of placing it online (convert the tables to MySQL and use PHP). So there is the potential for more work in the future. Initially I am just after the basic structure.
## Deliverables
Actual requirements are included in the attached text file.