Applications such as Microsoft Access use query language to narrow down search results. A query can look at more than one field.
|Reg. number||Make||Model||Date registered||Price||Taxed|
This is a list of common terms used in query language with example usage based on the table:
- 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.
- 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.
- 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:
- [Make] = "Ford" AND [Price] < 8000
- [Make] = "Ford" OR [Make] = "Rover"
- [Make] = NOT "Citroen"