Populate excel dropdown list in Userform from Access Table

Is there a way to populate a dropdown list in a userform from a list in Access table? We have projects that are set up in excel and when they become projects we move them into our database. I would like to create a userform to do this, so I can automate the process and have some data validation so there not multiple entries for the same item. I know I can create tables in excel, but I need them to be dynamic, so as we add items to the database, the dropdown reflects it. Thanks for looking and let me know if I can give you more info to help.

thanks in advance

I was just curious if its possible to do, not looking for someone to do it for me. I learn much better by doing. Not sure what visual information you need? I can post my userform showing the dropdown list I would like to populate with data from an Access database, or the code showing the userform initialize if needed?

I appreciate the help. I will look into that. I pulled the data from the database and made a table on our network, but this only works if there is an existing entry. I guess I could make some code to add to the names, if not there, but thought there might be a way to just use the access table.