Explain the difference between AND and OR criteria.

What will be an ideal response?

AND: All criteria must be true in order for the record to be selected for a datasheet. The criteria are entered on the same row of the query grid.
OR: Any single criterion must be true in order for the record to be selected. The criteria are entered on different rows of the query grid.