Question merging access dates with outlook calendar

[antonyx]

hi, i have a database with a single table..

DRIVER TABLE

the driver table has several fields such as

Insurance No.
Insurance Start Date
Insurance End Date
MOT No.
MOT Start Date
MOT End Date

etc..

there are about 50 drivers in the database.

i want my outlook calendar to notify me when any one of my drivers insurance or mot is about to expire..

this is my initial research and the outlook calendar seems the obvious path to go down.. is there a better way to do this?

the overall goal is to be notified through a calendar type view of when certain dates in my database have been reached..

 

[Rabbie]

Yes. you need to look at your design and normalise your data. MOTs should be linked to a vehicle not to a driver.

Try searching this forum for Normalization. Once you get your data properly normalised you will find it makes everything else much easier to do.

See this link for an overview of Database Design

 

[antonyx]

hi there.. i was just using this as an example.. i will most definately normalise the data.

i just wanted some info as to if and how a date record could be linked to outlook?