Hello, I have a table in access that has Name, Age, Address, Phone columns. I also have an excel worksheet that has headers for Name, Age, Address, Phone. I have never really done office development before, but how would I go about doing the following?

If I type the Name of someone under the name header, it will automatically pull the rest of the data associated with that name (Age, Address, Phone) from the access database...and put it in the 3 columns to the right of the name in the same row?