Transcript Relational Operators and Reports

Relational Operators and Reports
Learning Objectives
All:
Will be able to recognise the different relational operators in a
database
Will be able to create a report in a database
Most:
Will be able to apply relational operators to different situations
Some:
Will be able to create reports independently within a database
Relational Operators
>
Greater Than
<
>=
Less Than
Greater Than Or Equal
To
<=
<>
Less Than Or Equal To
Not Equal To
=
Equal To
Using the Whiteboards, SHOW ME the
operator for each of these queries:
1.
2.
3.
4.
5.
6.
Less than £200
Greater than £300
Equal to or more than £500
Less than or equal to £150
Greater than £225
Everything that is not equal to £250
The First Customer Of The Day
I want to know all the hotels in
Italy by their star rating, which cost
less than £300 in August.
Your Turn: Create The Query
Remember to save the query (and name it).
I want to know all the hotels in
Italy by their star rating, which cost
less than £300 in August.
When you have completed it, Stand Up!
You can help those around you aswell
Creating a Report
Going to show you how to
create a report in a
database
Your Turn: Create The Report
Using the query from earlier (About Italy) and
create a report to give to the customer.
On TALMOS is a guide to creating reports and
creating queries
I want to know all the hotels
in Italy by their star rating,
which cost less than 300
pounds in August.
Time to put it all together…
Going to create both the QUERY and
REPORT for the second customer of the
day.
REMEMBER TO SAVE YOUR QUERY AND
REPORT
I want to see all the hotels
showing their star rating which
cost more than 200 pounds in July,
grouped by country.
TALMOS Has Guides
Plenary
Write a number on the whiteboard and put your whiteboard in
the air
Going to write relational queries on the board.
If you MEET the criteria, you can pack up one of the following:
Pencil Case
Journal
When you get it right the third time, you can return the
whiteboard and pen and put your bag on ready to go