CAMBRIDGE NATIONALS CREATIVE IMEDIA ICT RESOURCES WILL BE REMOVED ON 1/9/2018 PLEASE SAVE ANY YOU STILL WISH TO ACCESS.
  • Home
    • Welcome
  • Unit 1: R081
    • Unit Overview
    • Lesson Resources
  • Unit 2: R082
    • Unit Overview
    • Investigating Digital Graphics
    • Planning your digital graphic
    • Creating Digital Graphics
    • Feedback & Evaluation

INTRODUCTION TO databases

Lesson 1: The Big Picture:
Students learn about the basic terminology of a flat file database. They also learn basic skills to add, delete and edit the data.

Learning Objectives:
Know the basic features of functions of a database

Learning Outcomes:
  • Identify the basic parts of a database
  • Demonstrate how to add, delete and edit a record.

Success Criteria
:
  1. Name the parts of a database
  2. Add records
  3. Delete records
  4. Edit records
  5. Be accurate with the editing
Resources
Starter: Line up
1 Starter
File Size: 647 kb
File Type: ppt
Download File

2 Overview
File Size: 872 kb
File Type: ppsx
Download File

Help Me!
Picture
3 Practice
File Size: 589 kb
File Type: accdb
Download File

3 Game
File Size: 360 kb
File Type: ppt
Download File

3 Homework
File Size: 14 kb
File Type: pdf
Download File

Picture
Lesson 2: The Big Picture:
Students are learning how to import data into a database and interrogate the data with various Queries that they create

Learning Objectives:
Know how to create  a range of queries and demonstrates an ability to adapt 'criteria' to meet requirements

Learning Outcomes:
  • Understand what a Query is
  • Know how to create a range of Queries
  • Demonstrate how to select correct criteria for a given Query

Success Criteria:
  1. Import data
  2. Create a parameter query
  3. Create an AND query
  4. Create an OR query
  5. Sort the data in a query
Resources 
Lesson Starter
example.xlsx
File Size: 74 kb
File Type: xlsx
Download File


Importing Data into the Database: 
Picture
Parameter Query
Picture
And Query
Picture
Or Query
Picture
Sorting
Picture
www.camnat.co.uk
  • Home
    • Welcome
  • Unit 1: R081
    • Unit Overview
    • Lesson Resources
  • Unit 2: R082
    • Unit Overview
    • Investigating Digital Graphics
    • Planning your digital graphic
    • Creating Digital Graphics
    • Feedback & Evaluation