access vba: change every value of a field with multiple criteria

[orimpila]

Hello! I made this code in excel, and I'd love to get it working in access.

Sub dips ()
Dim area As Range
Dim cell As Range
Set area = Range("A1:A300")
For Each cell In area
If cell.Value = "11" Then
cell.value = "aa"
Else If cell.value ="22" Then
cell.value = "bb"
End If
Next cell
End Sub

How do i set the wanted field? And how about the loop? I tried UPDATE in SQL but couldn't get values to change with multiple criteria. My boss just assumed if i know excel i know acces :/

[RuralGuy]

How many fields does each record have? How many records in the table?