To prepare yourselves for the next session ...
Look over these for simple queries
In Access 2007: The Missing Manual, 1st Edition,
read 7. Manipulating Data with Queries.
- You may find that re-feading the Wikipedia entry on Structured Query Language (or SQL) will be more useful now.
You might also want to look at Microsoft's tutorial on queries.