|Databases
- Factory Personnel (N Williams)
Interrogate a database of factory personnel. Add records, sort records and search records on more than one field. Download includes copy of database in csv format.
- People Database (N Williams)
Interrogate a database of company personnel. The student will have to add/delete records, sort records in alphabetical order, search the records on three criteria, search the database using a wild card and print selected fields. Includes data file in csv format.
- Product Database (iwChameleon)
Create and interrogate a database of company products. The student will have to search and sort the records, add/delete records and create additional fields.
- Book Club Membership Database (iwChameleon)
Create and interrogate a database of pupils belonging to the book club. The student will have to search and sort the records, add/delete records and correct errors.
- Hotel Database (N Williams)
Interrogate a database of hotels. The student will have to add/delete records, sort records in alphabetical order, search the records on more than one field and search the database using wild card characters. The data file is also available for download.
- Stock Control Database (N Williams)
This is a stock control system consisting of adding, sorting and searching records in the stock. The student worksheet has been written to go with MS Works database specifically so may need to be re-written. In any event, the accompanying data file is in csv format and will therefore import into most database programs.
- Cars Database (1) (N Williams)
Interrogate a database of cars. The student will have to add/delete records, sort records in alphabetical order, search the records on more than one field and search the database using wild card characters. The data file is also included in the download.
- Cars Database (2) (A Atkins)
This task requires the student to create a simple database of car details then perform simple search and sort exercises. Skills are emphasised by student writing down the process used in their particular database application.
- Hotel Database & Data Capture Form (Foundation) (iwChameleon)
The task is to design a data capture form to collect details about hotels for the local Tourist Information Centre. Create the database and then perform simple search and sort exercises.
- Zoo Database, Data Capture Form & Memorandum (Foundation) (iwChameleon)
The task is to design a data capture form to collect details about animals in a zoo. Create the database and then perform simple search and sort exercises. Write a memo about coding data.
