There are two methods to achieve this.
First is a check constraint.
Advantage: easy to apply, requires no further tables.
Disadvantage: if ever you need to change the range you need to execute DDL statements to alter the table. Also, you can't execute the DDL using the Access interface. Intermediate Microsoft Jet SQL for Access 2000
Second is a relationship to a table containing the permissible values using a foreign key.
Advantages: you can show the permissible values in the GUI by reading from the related table. You can also store additional information about the rating (since the values are drawn from a table it is now an entity and can have further attributes). Ratings can be changed using DML
Disadvantage: Requires more objects to be created.
If you simply want to only allow numbers between 1 and 5 and you do not need to store any other information at all about the ratings, and things will never change then use the constraint. Otherwise use the related table.