Microsoft Access 2013- Help with Query Criteria

[kindz05]

Hi, I am fairly new to Access and am trying to Omit two words from a query search.  It works when I use the criteria [Not Like ("*elementary*")] to eliminate the word elementary.  I also need to Omit the word School and Schools as well.  I do not want any result to return if they contain these three words.  So I do not want to see "Dawson School" or "Lincoln Elementary" or "Academy Charter Schools". I cannot seem to figure this out.  Please help!  Thanks!

John

[Geek-9pm]

You have Microsoft Access 2013, which has some help built-in
Here are some guides that might help:
Examples of Access query criteria

Doesn’t have the specified string, such as Korea

Not Like "*Korea*"

For all countries/regions that do not contain the string "Korea".

Note the use of quotation marks, not parentheses.
Also:
Query criteria quick reference guide

Does that help any? 

[camerongray]

I'm not familiar with Access itself but in other databases you would add a second not like clause and and then together.  So you would have something that reads as "not like x and not like y"

[kindz05]

Yes!  Thanks guys!  The quick reference guide is great and the "not like" before each word is what worked.  There are not too many better feelings than finally figuring out a computer issue