G042 Lecture 12 Using Local Databases

1
G042 - Lecture 12Using Local Databases

• Mr C Johnston
• ICT Teacher
• www.computechedu.co.uk

2
Session Objectives

• Know how to search for information on a local
  database using both logical (Boolean) and
  relational (comparison) operators
• Present evidence for task c of the unit by
  searching a local database for statistics which
  aid your investigation.

3
Terminology

• Data Field
• A single piece of data e.g. Name.
• Data Type
• Each field has a data type could be text,
  number, date
• Data Record
• A series of related fields make a record
• Database Table
• A collection of data records
• Search Criteria
• Characteristics used to find specific records
• Logical (Boolean) Operator
• Used to create better search criteria AND, OR,
  NOT
• Relational (Comparison) Operator
• Used to create better search criteria - gt, lt, ltgt,
  

4
Using Operators

• I want to find all customers whose favorite type
  of movies are action or comedy have a customer
  rating over 5 and are not from Hillfields.

5
Other facilities Sorting Results
6
Other facilities Summarising Results
7
Task C

• Band 1
• Requires you to use logical or relational
  operators in local database searches,
• Band 2
• Requires to use a range of both logical and
  relational operators in local database searches,
• Band 3
• Requires to use a range of both logical and
  relational operators in local database searched
  and produce printed reports clearly showing the
  results.

8
Task Best Practice

• Download the local database which relates to your
  investigation
• Investigation1 relocate to Devon
• Investigation2 find a university course /
  location
• Look at the data in the table and write down a
  list of questions utilising operators which will
  help you answer your investigation
• Make queries and show evidence dont need step
  by step
• Make reports ensuring they are edited so titles
  and data field name make sense before printing.

9
Topic Exercise

• Create evidence which meets the needs of task C.
• Remember to print it out and place in your folder
  as you go along to avoid any printer credit
  issues.

10
Useful Sources

• Investigation1 Database
• Investigation2 Database
• Operator Help Sheet
• Making Reports In Access Resources Available
  Next Week