Some of you are struggling to fully understand database queries. Practising these skills is a much more effective way than just “memorising” the answer. Use this database to create the following queries in Microsoft Access. Check each one carefully to make sure it works:
- All books by Ed Viesturs
- All books by English or American authors
- Factual books that are not paperbacks
- Books about mountaineering written after 2006
- Books with 600 or more pages
- Factual books published by Penguin
After you have completed these, answer the following questions:
- In a supermarket database, describe the steps to create a query to show all products with less than 5 items in stock. [4 marks]
- In a crime database, describe the steps to create a query to show all robberies between 1 May 2011 and 15 May 2011. [4 marks]
- In a school database, describe the steps a teacher would take to create a query that shows all students with a predicted grade of less than 4 in any HL subject. [4 marks]
Leave a Reply