Yes, a calendar view is much better. The only problem is how to incorporate such complexity as in my rota in one form.You might want a full calendar view to see all the activities at once. Take a look at the Peter Hibbs calendar with my year view to add codes. You could add codes for MDT, PM. etc. Then you could have visibility of everything going on. You would just have to do an union query on your multiple tables to get it display all activities. You would also need to filter on consult ID.
Date Pickers, Calendar Controls, and Calendar resources
There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...www.access-programmers.co.uk
I think I though about Union query and tried to build it at the beginning but I failed and instead someone on this forum advised and helped me to use concatenate function to accumulate similar activities of multiple consultants into one cell.
This is how a page from my Rota/report looks like.