First,thanks for any assistance you can provide because I am unsure if MS Access iswhat I should be using and don’t want to try and create something and have itnot satisfy my needs. Right now we are only reacting, I want to see if I canmake MS Access proactive when it comes to everything I do.
I am a fleetmanager with about 100 vehicles. I have created an excel workbook with severalworksheets for tracking basic vehicle data, modifications to vehicles, monthlymileage, completed maintenance, accidents, etc.
From what I havelearned from youtube about Access, you need to plan everything on paper firstand that is what I did. I have not found any type of template that haseverything I need so the plan is to make template that I can send to otheroffices for them to populate with their vehicle data, is this possible?
Here aresome other basic questions to start:
- Can all of us be on the project atthe same time using MS Access with any issues?
- We have documents, like receipts andother items that need to be attached to this project but we also have creditcard software that the receipts need to be attached too, can they be copy and pastedinto and out of MS Access?
- Can we build some sort of maintenanceprompting database with emails so that when we enter monthly mileage itidentifies what should be happening the next month and sends email as areminder?
This is justthe beginning questions for my project. If anyone has any suggestions to helpmake sure I cover all bases please let me know. I am trying to get into a MSAccess class locally so at least I have someone local who can provide someassistance.
Thanks againfor your help.