I live in the, "accidental DBA" world and therefore lack the years-deep knowledge to use these systems as well as they are intended. I've maxed out Access and needed...

Yes, I commonly use the yearmonth (YYYYMM) scenario. However, I use the fieldname TimeKey so as not to argue with the system about any reserved words. Additionally, I...