Has anyone made a database for maintenance of machines.The use is for
industrial use
Quite likely there are several such; however, they would probably be
pretty specific to the maintenance of *their* machines, not yours!
You may want instead to create your own database from scratch.
Identify the "Entities" - real-life things, persons, or events - of
importance; each type of Entity will get its own table. Off the top of
my head you have a Machine entity (table Machines), a Maintenance Type
entity (table MaintTypes), each related one-to-many to a Maintenance
Jobs entity (MaintJobs). There will almost certainly be more tables
(staff doing the maintenance for example).
Think through the relationships between your tables, their Attributes
(Machine Serial Number, manufacturer, model, installation date, ...
for Machines; MachineID, MaintTypeID, MaintDate, Comments for
MaintJobs come to mind); build the tables; then build forms for use in
entering data into the tables.
John W. Vinson[MVP]
