Can someone point me in the right direction. I want to be able to access
data from one table in an Access database. In greater detail, I have a
spreadsheet that has about 4 fields that I need to pull Employee information
into. I would like to be able to select a drop down menu of employees, or
better yet, enters the employee's name as I type their name(index?). When
the name is selected it enters the other data fields like position,
location, etc.

Any help would be greatly appreciated!