Databases Systems
Using Database Queries
Name:Class:
Label the diagram
Answer each of the questions below, using the queries and filters in the database you have used in the lesson. Use the database called ‘Cinema Movies.mdb’
FIRST: PRESS: “Open Film Table” to answer the following questions:
- How many films has Mr. Coleman seen?
- Sort the table by FILM ID. What film NAME is film number 8?
- Using the filter, what film certificate are the following films?
KNOWING:
JUMPER:
STARDUST:
- Using the Filters, what film did Mr. Coleman see on 02/12/2006?
PRESS: “Film Date Range Search”
- Search for all films between 1st January 2008 and 1st August 2008. How many films were seen?
- Using a filter on your search results, find out how many of the films seen between January and June were given 5 stars.
PRESS: “Film Star Rating Search”
- Name three films which have been given no stars
- How many films were given one star?
PRESS: “Film Name Search”
- How many films have the word “Man” in? Write down one of the film names, its start time and number of stars.
- Using the appropriate query: find a list of all films which are a 12A certificate. Write down how many films there are.
- Order your results in ASCENDING order, by date. Write down the NAME of the film at the bottom of the list.
- Using an appropriate query, find out how many films were seen after 8pm.
- Narrow down your search results from the previous question to find out how many PG films were seen after 8pm (HINT: you will need to use filters).
- Using your search results from the previous question, write down the film NAME of film 104.
Extension Work:
- Using the appropriate query, find out which is the most visited screen. Use this information to create an appropriate graph in an appropriate application.
- Copy this graph into a new document and write a small report which explains what it shows and your findings.
- Try creating your own database table in Access which stores your friends names, and addresses.