I'm pretty sure between can be used in the validation rule for a field. You can probably get away with using "< 9999" if you need. You can set the validation rule for a given field in the design view for the table.
In MySQL, tinyint is defined as a bit, much like the "yes/no" datatype in access or the "bit" datatype in MSSQL. You can't have a tinyint longer the 1 bit, that's the definition of a tinyint.
This is off topic, but tinyint in MySQL, can have -128 to 127
doesnlt restricting it to tinyint(1) give -9 to 9?
will look at using between as a validation rule. Am doing this for a stupid coursework, where we don't actually build the system, we just give the DDL, but we have to use the access standards - bleuch. why, i have no idea, lol.
oh and when using int in DDL in access it sets it to Long Integer for some reason, and not just Integer? weird.