Can you associate a meaning to each value in Access 2007?

"You need to create a table which contains the relevant values for each number. Then simply create a relationship between the primary table and the secondary table. This would be the simplest and correct way of doing. However I have to admit I can't remember step by step how to do this in Access. However Microsoft has a fairly good article on how to do this here.

As far as the display is concerned you will create a new data view that retrieves the display value instead of the number and link everything to the view.

I am not aware of any other way to do this in Access."