Introduction To Unit 2

Introduction To Unit 2

Unit 2: Creating Systems To Manage Information 

Lecturers: Richard Dynes, Michael Allison, Shauna McKeown, Fiona Keenan 

Unit 2- What is the subject?

The BTEC specification (on canvas) introduces this unit as:

“…In order to produce information to support many business processes as well as our social lives, relational databases are widely used to manage and process data.

From the smallest in-house systems to stock control systems for large online retailers, databases are repositories of information that are a significant part of organisational operating requirements….”

What do you already know about databases?

Unit 2- What is the subject?

This unit is about relational databases:

You will study:

1. The theory and practices of databases
2. How to design databases
3. How to create databases (Implement)
4. How to test a database 

Unit 2- What is the subject?

This unit is about relational databases:

You will develop skills in Microsoft Access, part of Office 365. You will learn to create:

1. Tables
2. Queries
3. Data Forms
4. Reports 

How is this unit assessed?

This Unit is assessed by an External Exam

The exam is set and marked by Pearson, who are the BTEC awarding body.

You will be asked to create Database solutions using Microsoft Access under supervised conditions, over 2 consecutive days.

Day 1 (afternoon) – Part A, Design & Create Tables (3 hrs)

Day 2 (next morning) – Part B, Create Forms, Test, Evaluate (2 hrs)

Unit 2 Support- VLE- Canvas 

Office 365 From Home 

Unit Specification 

Any Questions?