AND & OR Criteria
Queries are one of the most useful tools in a database.
They allow you to take data that has been input into the database and output information (data that has context, structure and meaning).
So far you have looked at how to create a query with a single criteria. You can use more than one criteria in a query using AND & OR.
Using AND criteria allows you to search for records where two conditions have to be met. For example, you might need to search for everyone who lives in Leicester AND are male. In other words, city = "Leicester" AND gender="m".