Lesson+5

=Databases Lesson 5=

REMEMBER TO LOGON TO GOOGLE CLASSROOM!

Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6

Lesson Objectives

 * Understand how to create a report in a database
 * Be able to format a report in a database

Success Criteria
(5-6) Be able to describe why we use a report in a database (5-6) Create a customised report from a complex query (4-5) Define a report using the report wizard

Starter (5 mins)
Write YOUR definition of the word Report on the slip and put it on the desk at the front



Homework
Last weeks homework has been marked on Google Classroom - this weeks homework is to use your keywords spreadsheet and learn at least 5 keywords for this unit. I have added an up to date copy on Google Classroom for anyone whose own is not up to date

**Task (5 mins)** Open your database Open your Database classwork document on Google Drive

Class Activity (5 mins)
We will define a complex query

Task (10 mins)
Create the complex query and SAVE it as complex query Add cropped screenshots to your document

Task (5 mins)
Create a report from complex query using the report wizard

Task ( 10 mins)
Create a report from your complex query using DESIGN view

Extension Task
Create some extra queries & Reports

Plenary (5 mins)
Define a keyword for this unit