How to find records, name "like" keywords given in column in another table

[erxefera]

Hi!
Is it possible to make such query which will find all records that have
name like keywords. These words are collected as s dictionary in another table in column name.
Is it possible to make just one query or vb script that will search through all records using all of keywords given in dictonary?
example
dictionary:
abaccus
dolphin......
.....
query find records wich name is like abaccus or dolphin or........

Thank You in Advance for any advice cause i have big problem how to figure out.....I have to do this in my job......

 

[Smart]

RE:How to find records, name "like" keywords given in column in another table

In your query select the records you want
in the field that you want to search (criteria section)
Like "yourword*" Or Like "snextword*" etc

 

[erxefera]

Yes, but i don't want to make it manually,
if i have 169 keywords,
The search has to be done automatically but HOW???