Hello all. Hoping for some advise on the best way to tackle my DB.
Im new to Access DB's I have used them in the past and had a few attempts at making them, for the most part they get to a point where there workable.
you may have seen some posts from me about queries that I have been having trouble with on a current DB that I have been working on. Im at a point where i think i may need to re build this DB to have the functions to work in the right way.
and this is where im hoping for the advise. The DB I built i have been using for the past few weeks its a feet management DB, there are 2 main objectives for this DB.
1. to keep a record of plant/machine servicing times and inspections times (monthly, with the aim to work a month or to ahead with servicing dates)
2. to keep a long of plant/machine locations ( the get hired out and are always on the move to different location)
with that I would need to produce reports of the locations to hand to different people so they can carry out servicing and inspections at there locations.
as mentioned I have one in place now but im now finding holes where i have been using it.
so what would be the best way of going about getting some like this in place. i'm happy to upload what i have done already but im sure with me being novice my set up is not the best.
at present the company uses spreadsheets to track half this information but the address need to be found manually which is very time consuming as most of there records are wrong.