Queries in a Database

Remember a good tip is to add ALL the tables into the query and then you look for the fields required.

The Wildcard *

Remember the 2006 Exam example. In searching for G postcodes you would use G* in the Criteria box.

Query using OR

If you are looking for two items in the same field use OR. For example, if you wish to look for Branches in London and Birmingham, then typing in the Criteria box London OR Birmingham would return the correct results.

Query using AND

If you need items in different fields, then Access does it automatically for you.