Calculated Field based on the value of another field in the same table

[Strategon]

I am developing an app for an RPG. I need to track ability scores and a corresponding modifier. I was going to put this in one table and it would look like this:

Table (Ability Scores) Field 1 = Strength Field 2 = StrengthModifier

If strength is an 8 or 9; then StrengthModifier would be 1 If strength is a 10, 11, or 12; then StrengthModifier would be 2;

How would I do this in access?

[pbaldy]

Not sure what your question is, as you have already described the table as I would have it. 2 fields, and from your description 5 records.