Well, your teacher is right. What I'm saying is Ms. Access is using the same language and a limited function of VB, I think the syntax is quite the same when you're creating macro with Word or Excel.
I think you could create such limitation when you're designing form for your database in Access.
e.g. You're creating a textbox which named TxtMemberID which linked to your Member ID field in your database the simple syntax for limiting the entry would be like this :
Private Sub TxtMemberID_Validate(Cancel as Boolean)
If TxtMemberID.Text < 1 Or TxtMemberID.Text > 99999 Then
MsgBox ("Error. The accepted value must be between 1 to 99999")
Cancel = True
End If
End Sub
The syntax I describe above is a simple example of how VB language written. Of course you can use other graceful method of limiting data entry by using other means like string function (Str), etc.
I can't give you precise example because I'm not using and installing Ms. Office in my machine nor do I've ever doing VB Database Programming with Access (I'm using SQL Server as database).