Information handling softwareAND/OR/NOT queries

Applications such as Microsoft Access use query language to narrow down search results. A query can look at more than one field.

This is a list of common terms used in query language with example usage based on the table:

1. AND - use to find all records where the make is a Ford AND the price is less than 8000. This would return the Fiesta but not the Mondeo.
2. OR - use to find all records where the make is a Ford OR Rover. This would only return the Ford Fiesta, the Ford Mondeo and the Rover 200.
3. NOT - use to find all records where the make is NOT Citroen. This would return all records except the Citroen C4.

In query language, these examples would look similar to this:

1. [Make] = "Ford" AND [Price] < 8000
2. [Make] = "Ford" OR [Make] = "Rover"
3. [Make] = NOT "Citroen"