Searching multiple fields

[quinns]

I'm trying to design a database for sorting prospective employment candidates for a friend's business. I'm not particularly experienced with base, though I do have reasonable knowledge with access and am finding them very similar.

I'd like to be able to search the database with a collection of search criteria. For example, look for candidates that have a degree, live in UT and are willing to relocate (all of those are already defined fields).

I've gotten so far as to have one of these search constraints using a separate table for that particular field that references the main table that you can query from... but I don't know how to go about combining many of these... some kind of filtering process, I'm sure, but it has proven to be beyond me so far.

Does anyone have a good tutorial for this on-hand?

I'd really appreciate any help you guys could provide!