If you wanted to validate data, you can either create data validation at the table design level, or use a form and create the data validation on the form. I think if you must use a datasheet for data entry (since it is a personal database) then I would do data validation at the table design level. Working with datasheets is too problematic for this, I think.
Did any of that help?
Look it up at: http://wrox.books24x7.com