Databases: Searching, sorting and editing records
Database queries and reports
Introduction to queriesThis workbook assumes that student know how to set up a simple one table database in Access. They are then taken step by step through creating different types of query. Students can work at their own pace by following the instructions given in the workbook. (subscription only) |
|
Queries 2This task provides students with a pre-prepared database. They are asked to write specific queries using the database. Assumes some knowledge of Access and writing queries. (subscription only) |
|
Queries 3This task provides students with a pre-prepared database. They are asked to write specific queries using the database. Assumes some knowledge of Access and writing queries. (subscription only) |
|
Cars database and queries (2007)Here is an Access database based on cars. It contains 70 records. There is an accompanying question sheet which will enable you to check whether students understand datatypes, validation rules and how to write a query in order to extract information from a database. (subscription only) |
|
Oregon Murder databaseThis database and full set of accompanying worksheets has been adapted from the original oregon murder database by Andy Longstaff. Many thanks to Andy for letting us publish his work here. This is a large file - approximately 3.5mb. |
Copyright © www.teach-ict.com