I'm VERY new to access and am trying to build a database. I think I have the basics down, but now I am trying to do a query or maybe macro to find a replace multiple sets of data:

for every place under my column "Item Type" where the number equals one of the following: 911000002100, 911000002101, 911000002102, 911000002103, 911000002110 - I need the numbers to be changed to SUB.

Every place that the numbers in the "Item Type" column equal: 911000002200, 911000002201, 911000002202, 911000002203, 911000002210 - I need the numbers to be changed to UNSUB.

Everyplace that the numbers in the Item Type Column equal: 911000002500, 911000002501, 911000002502, 911000002503, 911000002510 - I need the numbers to be changed to PLN.

Everyplace that the numbers in the item type column equal: 901000001100 - I need the number to change to PE.

Every time the number in the Item Type Column equals: 911000002300 I need the number to change to PERK. Every time the number in that column is: 92000001000 - I need the number to change to WSY.

Everytime the number in that column is: 901000001110 - I need the number to change to SGE.


All these numbers are in the same column. When looking at access, it seems like I will need to write something in Visual Basic, but I don't know anything about visual basic. Does anyone have some suggestions about what I will need to do?