I am building a database for a small property management company.
They have 6 people in the company and have around 200 residential units on their books.
All properties have fixed schedules for cleaning, garden maintenance, routine inspections and invoicing.
They want to schedule these activities in an Outlook type way. For instance for a specific property, they want to be able to schedule weekly gardening service like:
Activity: Gardening Service
Frequency: Two weekly
On Which days: Tuesdays
Up to when: Until terminated.
Responsible Person: George Johnson
Cleaning Company: Flash Cleaners
Out of this they want to extract a list of People responsible, Properties, and Tasks for any given nearby day.
How should I approach this? Especially the continuance "Until terminated". I suppose one can just fill a table with dates for Tuesdays for 10 years. Then after 10 years reminders just suddenly stops. Is that the right way? Do you know if that is the way that Outlook does it? Can and should I use Outlook for this process?
Are there any ready Access templates for this process that you know of?
I appreciate inputs.