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!

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

---

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: 

Parameter Query

And Query

Or Query

Sorting