Recent content by Gin

i need some help with field properties in a table , for a college assignment and i'm new to access , so please help me T_T with those : 1.making the last letter capital(uppercase) and the rest not(lower case) and limit to 15 character . 2.the date should be between 1/1/2012 and 31/12/2012 ...