Teach Computing

Revision notes, activities, lesson plans, teaching ideas, and other resources for GCSE, A-Level, and IB Computer Science teachers and students.

What's New

Boolean logic worksheet pack

These three Boolean logic worksheets have exam style questions on logic sta...

Edexcel Computer Science (9-1)

by Ann Weidmann et al Amazon.com | Amazon.co.uk | Book Depository This bo...

Dijkstra's algorithm video

This video is probably the best explanation of Dijkstra's algorithm for IB ...

Input-Process-Output (IPO) Model

The Input-Process-Output model is a simple topic but some students sometime...

Hexadecimal

A comprehensive review of hexadecimal. The video covers not only how to u...

Subprograms, Local Variables & Structured Programming

Subprograms are known by several different names - methods, functions, proc...

Utility Software and Models

Some students find the difference between operating system software and ut...

Data Structures

This video explains different types of data structures - 1 dimensional ar...

Operating System (OS) - GCSE Computer Science

A detailed overview of operating systems, starting with the general tasks t...

3.5 Databases

Click here for recommended Edexcel GCSE Computer Science textbooks.
Database tutorials

Database tutorials - GCFLearnFree YouTube channel

GCFLearnFree's YouTube channel has videos on a wide range of subjects, including Microsoft Access. The videos start with the absolute basics, introducing the background concepts and simple single table databases (very useful for the IGCSE Computer Science course). They then move on to more complex topics such as designing different types of queries, creating forms, and formatting reports. Video are generally less than 5 minutes, which means they get straight down into the details and make it easy to skip to the right part. The video focus on Access 2013 but students should be able to adapt the techniques to other versions too.


Updated: 2015-04-11
Databases revision

Databases

A good overview of database theory, which is sufficient to cover the syllabus for most GCSE courses, and is a good introduction to the topic for A Level and IB courses. The differences between structured and unstructured data are covered, along with database basics (fields, records, tables). The second half of the video explains relationships in more detail, including 1-to-1 and 1-to-many relationships.


Updated: 2018-02-17