Part A Exams Practice

1 / 16

Slide 1: Slide

Ilearningdeal@gmail.comPrimary EducationLower Secondary (Key Stage 3)Upper Secondary (Key Stage 4)Further Education (Key Stage 5)Higher Education (degree)Higher Education (non-degree)Special Education

This lesson contains 16 slides, with interactive quizzes and text slides.

Items in this lesson

Part A Exams Practice

Slide 1 - Slide

Data Set

The Next slide shows the data set

Slide 2 - Slide

ucguk-my.sharepoint.com

Slide 3 - Link

ucguk-my.sharepoint.com

Slide 4 - Link

Slide 5 - Slide

Please see the solution

Next slide see the solution.

1. ERD

2. Fill in tables

3. Query

Slide 6 - Slide

ucguk-my.sharepoint.com

Slide 7 - Link

Using the slide above

1. Produce Print screen for ERD

2. Print screens for all your tables and Validation in Design View

3. Print Screen of your Filled in tables

Slide 8 - Slide

From your ERD Diagram- Describe the relationships

Slide 9 - Open question

Query Design

Slide 10 - Slide

Slide 11 - Slide

Tutor to lead

Tutor will go through queries

and student to follow and do their own one on the link provided

Slide 12 - Slide

Slide 13 - Drag question

Here is the Data Set

Jan 2022

Slide 14 - Slide

The End

Slide 15 - Slide

Slide 16 - Slide

Part A Exams Practice

Items in this lesson

Slide 1 - Slide

Slide 2 - Slide

Slide 3 - Link

Slide 4 - Link

Slide 5 - Slide

Slide 6 - Slide

Slide 7 - Link

Slide 8 - Slide

Slide 9 - Open question

Slide 10 - Slide

Slide 11 - Slide

Slide 12 - Slide

Slide 13 - Drag question

Slide 14 - Slide

Slide 15 - Slide

Slide 16 - Slide

More lessons like this