Practice: Movies Database
More Adding, Deleting, Editing, Searching & Sorting Records
Use what you have learnt in the previous exercises to complete the following exercise. You may have to watch previous videos to remind yourself of how and what you have to do.
Answering some questions will require:
- A sort;
- or a Search
- or both.
What you have to do!
Open the MOVIES database file and answer the following questions in Exercise 13 in the General section of your progress grids.
- How many 18 certificate movies are in the database?
- How many movies are rated either Poor or Average?
- Write down the ID of the movie that is the longest in terms of time in the database?
- How many romantic comedies are in the database?
- How many family comedies released between 1960 and 1985 are stored in the database?
- How many movies lasting longer than two hours are either action or drama?
- How many movies lasting longer than two hours are classified as being both action and drama?
Mark off Exercise 13 in your Progress Grids
