Creating a Query - Access 2007 Database

[SolarMidnite]

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!

 

[Future Bruno]

A:Queries are an important part of working with databases. They enable you to retrieve only the data that you need for a particular purpose. To create a query in Access, you can use the Query Design View. You can select the tables or queries from which you want to retrieve data and then add criteria to narrow down the results. For example, if you want to see all the movies rented by a particular customer, you can create a query that joins the Rentals table and the Customers table. Then you could specify the customer ID as a criterion to return only the rentals by that customer.