how do I do something similar to look up values in Access?

right now I use queries in Excel to pull large tables into separate sheets in Excel and then I use vlookups to query these sheets. I want to get rid of that middle step if possible. Can I query the access database with a function or through VBA code?

Ex:

Say I have code 556752 and I want to look up the description from a table in Access, how do I do that?