I have encountered the following problems:
I am building a training record db for my company with ACCESS.
The table involve Training Course title, offered Organization and Date of the Training Course.
For Training Course date:
1) Continuous Date like: 1 - 4 July 2009;
2) non-continuous date like: 7, 12, 15, 24 July 2009;
3) a bit of both: 1 - 4 July 2009, 16, 27, 30 August 2009

In order to entertain all the above combination, during table building do I need fields like StartDay, EndDay, Day1, Day2 ....... on one single record? Then this will against the normalization rules of Database! Even though that's the way to build the Table, how can I pursuit the query, since all the days are in different columns?