To start with you will need to have a recordset on your results page that selects all from this table.
Next you will apply the DataAssist Search server behavior. I would suggest that you work on this one criteria at a time and test it out in between each of them to ensure that it is still working.
For your first criteria you would select the column from the db, the type for the column should be text, then the comparison should be includes. For the type you would use keyword, then for the edit field name you would just select the form field from the search page that you will be entering this value into.
When you are done with this step you should test it out to confirm your results. When you get it working the way you would like you can move onto the next search criteria. Post back if you have any problems or questions about any of this.