Hey there guys and girls, so starting off I'm extremely new to Access, it's been years since I last had anything to do with the program but I'm (albeit slowly) picking it back up and have been asked by my employer to try making a DB for her slowly expanding company.
Now what they are wanting is a system that can manage all their company vehicles and company equipment and the maintenance for each piece individually with records that span back up to 3 months. Now so far I have the basic tables made of both the vehicles and equipment, and am currently trying to figure out if I would need to make an individual table for each vehicle/equipment piece in order to manage the maintenance services performed. They are also wanting to have an inventory list of sorts for each vehicle to save time on parts numbers and to help keep a better track of what we're using more of to help free up space in the....sty that is our current inventory "corner".
I guess I'm trying to ask that in order to keep the DB functioning at peak performance what would be the best way to record all this information? Separate tables for each vehicle/equipment piece and then subsequent tables regarding the parts list and then service history? Any suggestions would be appreciated, since I feel like I'm tackling a mountain with a rusty spoon.
((Also if you need me to try and clarify any of this feel free to say so, I'll do as best I can to convey my growing insanity a bit better)