Field name in MS Access table - s1
data type - text

I use this field to store student marks. 

'AA' will be entered if the student is absent and therefore I have selected text data type for this field

I want to restrict data entry to minimum marks = 0 and maximum = 75

How do I enter validation rule in this text field?