ids 200 lab homework assignment

This is Access database question. I have no idea how to do the relationship and queries? Could you please guide me through all the detials?