I'm currently working on a project in which we have to create a video rental database using MS Access 2007. We are asked to make use of a query. I'm still a bit unclear on what exactly that entails. If I understand correctly, queries are used to narrow down to only the data we want to see. Right now, I have four tables: Rentals, Media (Eg. Movie Title), Customers and Categories (Classification of movie: Blu-ray, DVD, etc). So how exactly do I involve a query in this? The project outline was not very specific beyond asking us to use a query as one of the requirements. I've already sent my instructor an email, but I have not yet received a response so I was hoping that someone here could help me out until then!