Address Field Cleanup

I have two fields "address" and "plaintiff address" in table jpdat

Sample Data                           expected outcome "address"    expected outcome "plaintiff"

123 Main Street                     123 Main St                                123 Main St
123 Main St #21                    123 Main St ,21                           123 Main St unit 21
123 Main Street #21             123 Main St ,21                            123 Main St unit 21

I have created two other tables that have fields "badstring" "goodstring" in tables "Address_Correction" and "Pltf_Address_correction"

Example Data
Bad String        Goodstring
Street               St
Str                    St
Avenue           Ave  

Etc.....

First I am a novice at Access 2000
1. I am looking to clean up addresses in a form based on JPDAT table, using the information in the prespective  correction tables. How can I do this? The Address field and the PltfAddress Field need slightly different cleanup. that is why I have two correction tables.

2. if the end of the address such as 123 main st 21 is numbers I want to transfer that into the apartment field. Can I do this based on if there is a street type and if there is not one present.

Thanks for your help in advance

All help would be appreciated.