Tuesday 10 May 2016

Unit 6 - Databases - Lesson 2/3 - Queries and SQL

Learning Objectives:
  • Learn how to Query a databse
  • Create simple SQL statements to extract, add and edit data

Download and Save the Data base HERE

Main



Worksheet 3 - HERE




Worksheet 4 - HERE

Thursday 5 May 2016

Unit 6 - Databases - Lesson 1

Learning Objectives:
  • To discuss some of the many computer systems which may hold data about you or your family on a database
  • To learn how this data is held so that information can be quickly retrieved
  • To learn some database terms: record, field, table, primary key, index
  • To set up a simple table in Access and enter some records

Main


Download and Save the SportsDay database HERE

Databases Worksheet 1

Exam Questions gone through in class:


Databases Homework 1


BBC Bitesize - Revise & Tests HERE