Mr Mark's ICT Website
  • Home
  • iGCSE
    • iGCSE ICT NOTES
    • Types and components of computer systems
    • Input and output devices
    • Storage devices and media
    • Networks and the effects of using them
    • The effects of using IT >
      • Employment
      • Working Patterns
      • Microprocessors in the Home
      • Health Problems
    • ICT applications >
      • Communication Applications
      • Data Handling Applications
      • Measurement Applications
      • Microprocessors
      • Modeling Applications
      • Applications in Manufacturing
      • School Management Systems
      • Booking Systems
      • Banking Applications
      • Medical Applications
      • Library Applications
      • Expert Systems
      • Retail Applications
      • Recognition Systems
      • Monitoring & Tracking
      • Satellite Systems
    • The systems life cycle
    • Exam Paper 1
    • Exam Paper 2
    • Exam Paper 3
    • Website authoring
  • Grades
    • Grade 6 >
      • Spreadsheets
      • Coding
      • E-Safety
      • Computer Animation
      • Video Editing
    • Grade 7 >
      • Databases
      • Computer Peripherals
      • Computer Hardware
      • Image Editing
      • Flash Animation
      • Computer Animation
      • 3D Design
    • Grade 8
  • Class Rules
  • Awards
    • 7B1
    • 7B2
    • 7B3
    • 7B4
    • 8B1
    • 8B2
    • 8B3
    • 8B4
    • 8B5
    • 9B1
    • 9B2
  • Contact
  • Games
  • Home
  • iGCSE
    • iGCSE ICT NOTES
    • Types and components of computer systems
    • Input and output devices
    • Storage devices and media
    • Networks and the effects of using them
    • The effects of using IT >
      • Employment
      • Working Patterns
      • Microprocessors in the Home
      • Health Problems
    • ICT applications >
      • Communication Applications
      • Data Handling Applications
      • Measurement Applications
      • Microprocessors
      • Modeling Applications
      • Applications in Manufacturing
      • School Management Systems
      • Booking Systems
      • Banking Applications
      • Medical Applications
      • Library Applications
      • Expert Systems
      • Retail Applications
      • Recognition Systems
      • Monitoring & Tracking
      • Satellite Systems
    • The systems life cycle
    • Exam Paper 1
    • Exam Paper 2
    • Exam Paper 3
    • Website authoring
  • Grades
    • Grade 6 >
      • Spreadsheets
      • Coding
      • E-Safety
      • Computer Animation
      • Video Editing
    • Grade 7 >
      • Databases
      • Computer Peripherals
      • Computer Hardware
      • Image Editing
      • Flash Animation
      • Computer Animation
      • 3D Design
    • Grade 8
  • Class Rules
  • Awards
    • 7B1
    • 7B2
    • 7B3
    • 7B4
    • 8B1
    • 8B2
    • 8B3
    • 8B4
    • 8B5
    • 9B1
    • 9B2
  • Contact
  • Games
Search by typing & pressing enter

YOUR CART

Databases

Picture


A database is a collection of data or information which is stored in a logical and structured way


Databases can be either paper-based or computerized collections of data.

Paper based database examples

Picture

Paper based databases 

Advantages: 

*Cheap to set up
*Don’t need electricity, so will work if you have a power-cut
*Don’t need a computer – which is expensive
*Can carry them around with you
*Don’t need training to learn how to use them

Paper based databases

Disadvantages

*Can be lost
*Can’t easily make back-up copies
*Hard to update or make changes
*Card systems can get in a muddle if cards not replaced in the correct order
*Can take a while to search for a particular record

Computerized database examples

Picture

Computerized databases 

Advantages: 

*Can easily make back-up copies
*Can easily make changes
*Can easily sort data into order e.g. alphabetic
*Can search for particular records very quickly
*Can import or export data to/from other packages

Computerized databases

Disadvantages

*Can be expensive to set up if you have to get a professional to make it
*If there is a power-cut, you can’t use it
*You need to have a computer
*Cannot carry it around with you – unless you take a computer
*You often need training to learn how to use them


Sherlock Holmes activity

Can you help Sherlock Holmes to solve crimes?  Use the database provided to interrogate the database and create queries to help you catch the correct villain.

Picture




​Click here to solve the crimes


Database Vocabulary

Your school keeps a lot of information about every student. 

Think of some of the information they keep about you.

*Name*
*Date of Birth*
*Address*
*Parents name*
*Doctors name*
*Phone number*
*Email address*
*Attendance*
*Grades*

Each of these is one piece of information about you.

Each of these different types of information is called a Field

Picture

All of the ‘fields’ are put together to make a ‘Record’


A ‘Record’ is all of the data about one person or one thing.

Picture
Picture

Picture

Search Activity

Download the Excel file here and using the filters, can you fill in the missing information

lesson3.xls
File Size: 90 kb
File Type: xls
Download File

lesson_3_student_sheet.doc
File Size: 64 kb
File Type: doc
Download File

Picture

Super Hero Database

-Download the super hero database here

Picture
filmcharacters.mdb
File Size: 2568 kb
File Type: mdb
Download File

1. Use the table provided to create a form that is suitable for the superhero database 

2. Choose suitable themes for the fields, backgrounds, fonts,  colors in (design view)

3. Add a new field called picture and set the data type as "OLE Object"

4. Add a image to each super hero (make sure you are in form view first)


Creating Queries

Download this document and create queries to find the most suitable superheros for the movie

Picture

Databases.ppt
File Size: 2687 kb
File Type: ppt
Download File


Starter Activity

Can you solve the crossword puzzle?

Picture