I'm having trouble thinking of how best to describe it, but here goes...
In access, go to the query tab, and then click "Create a new Query in design view"
THe screen you get will be divided in to, and there will be another window with all of tables listed.
Double click the tables you would like to add, and then click close when you are done.
If you need to set up joins, you can now do it by dragging one field to another, then right clicking and editing the properties to choose the type of join.
Double click any fields you want to return and they will appear down in the bottom section.
Down in the bottom section, you can now add criteria, just in the format
LIKE '*' & 'Keyword' & '*'
Put it on different lines for each field to make it an OR criteria.
Since I suspect that you may need to use SQL anyway, you can now select SQL View from the View menu, and will have the SQL nicely formatted.
There is also a way to have the query prompt you for the variable in the criteria, but I haven't done that for a long long time.
Typically I use this to build my SQL strings, and then transfer them to my code - Heck, I even use it when I need to build SQL for PHP/MySQL apps!
Yell if you need more info,