Fleet Managment Database

[PhilDUX]

Hello i would like to set up a database for inspection dates & reminders, Test due dates & reminders. our vehicles are inspected every 6 weeks can i set up a data base to automaticly display a message 7 days prior to the event is this something a simpleton like me should not do.

 

[Sergeant]

Yes, that is possible.
For the most part, you could only expect these warnings to be produced when you OPEN the database. Your database could not calculate things that are coming due while it is closed. (That's not to say it's impossible)
That said, if you would like to make such a database...let's roll!
If you are starting from scratch, just post each stumbling block as a new thread, and you can expect to find help here.
If you need help getting started, just say so.

Sarge.

 

[PhilDUX]

starting from scratch. i am a complete beginer at this so any help would be greatly appreciated. installed access started new database & saved db1.mdb

 

[Batty]

Phil,

Before you get started you should use the P&P method. This involves getting a pen, a bit of paper and writing down all of the information you need to store.

Then next to them write what type of data they are. I.E Text, Number, Date etc.

Then write down how often this information will be entered, and how often it will be updated after it is entered.


This will become you table structure. The reason i asked you to write how often the information is updated is because for something like a car it will only be entered once, then refered to many times.

Let me know how you go.

Oh and uhh maybe you should name the file something a little more recognisable.

Batty

 

[Sergeant]

That's good advice from Batty. I started using Access about two years ago, and it took me over a year to realize how important the planning is. Now I start with pen and paper.
A bit of advice...
1. Forget about Excel...for a while, at least. Try to resist the urge to make one big flat table in your database.

2. Read this forum. Search it when you have questions. If you don't find your answer, post your question. I refer to the forum more than my books.

3. For your primary table, try to boil your vehicle info down to what is absolutely necessary to identify a vehicle, including any data that will NEVER change (like VIN, date of manufacture, etc...). Anything else goes in another table. (more or less)

Good Luck,
Sarge.

 

[PhilDUX]

we will have vehicle registration, inspection intervals for these are 6 weeks about 8 times a year, test is once a year and tachograph tests are every 2 years. trailers are inspected every 8 weeks which is approx 7 times a year, test is once a year.

i would like the database to automaticly display (some how) when a event is going to happen 7 days prior to the actual due date and will not go away until it has been acknowledged. And a sheet that will show everything and colours to show due events and late events dose this sound as though it can be done.

 

[Uncle Gizmo]

I'm sure there was a vehicle related example database posted here somewhere , I should have a look at that first if you can find it.