Filtering queries

[NUWildcat]

Is there any way that you can have a query that prompts for a filtering criteria, but instead of having that criteria be for just one of your fields, have the criteria be a string that could include a criteria for anywhere from one to all of the fields? i.e [Name] = 'XXX' and [Job] = True or [School] = True

 

[NUWildcat]

So is the form than connected to that query when you first create it? Or else how do you get the information into the form that you want to be filtered? Sorry if this question is juvenille, I'm just not very accustomed to Access and if you could walk me through it, it owuld be great. Ive already found a way to create my string now I just need to apply it.
Thanks!