Transcript Databases – Lesson 1

DATABASES – LESSON 6
Key Stage 3 ICT
HOW DO DATABASES AFFECT YOU – TASK 6A

In your booklets,
List 5 places that use a database and why?
OBJECTIVES



Know how to write reports from a database
Know how to use a query to select records for a report
Know how to customise a report
OUTCOMES



All: Will have created a report in access
Most: Will have used a query for the reports records
Some: Will have customised the report
REPORTS TO YOUR BOSS.



Queries are purely for selecting records – they
are not suitable for end users.
You cannot customise them, ie add titles,
headings or colours.
Lets learn about Reports – these you can
customise.
WHICH ONE IS MORE USER FRIENDLY?
WHAT IS A REPORT
Has titles
Has a header
Has images
Has data
headings
Has the data
Has a footer
Easy to read
HOW TO CREATE A REPORT
What does a query do ?
Selects records from the database
Select the query you
want to report on
ADD THE FIELDS YOU WANT TO SEE ON
THE REPORT.
Click NEXT
button THREE
times . . .
. . . Click
FINISH
button
IN A FEW CLICKS YOU GET….- TASK 6B

Your turn to create the report using the “crime 1”
query.
CUSTOMISING THE REPORT.


Right click and open the report in Design view
Demonstration of how to…
Change background colour
Change Text colour / size / font
Insert Image
Edit Titles
Not to amend Data Name
CREATE A REPORT ON ANOTHER OF YOUR
QUERIES TO BE AS GOOD AS….
Has titles
Has a header
Has images
Has data
headings
Has the data
Easy to read
Has a footer
Extension:
Now go and annotate and describe the main design features of
your report..
PEER ASSESSMENT IN YOUR BOOKELTS
Has titles
Has a header
Has images
Has data
headings
Has the data
Has a footer
Easy to read
PLENARY – TASK 6D

Complete the Unit quiz in your work books.
END OF UNIT
Open the ICT levels spread sheet and find the
Database
 Read each orange box and answer in the Orange box.


Also fill in the www and ebi boxes.