Topic 8

Topic 8

1. Information handling software. Any software used to store, manipulate and output information

   • Covers
     • Database software
     • Databases created using spreadsheet

2. Updating-Deleting and sharing records

   • Delete- Remove data no longer needed
   • Update- Change the data to bring up-to-date
   • Search- Look for specific records that match certain criteria

3. Operators are used to construct search criteria and include:

   • = Equals
   • > Greater than
   • < Less than
   • <> Not equal to
   • >= Greater than or equal to
   • <= Less than or equal to

4. Structure of data

   • Data
     • Unprocessed Information
       • For example 01012011
   • Information
     • Data that now has been processed and has a meaning
       • For example 01/01/2011
   • Field
     • An item of data or a fact
       • Example -surname- Jones
   • Key Fact
     • Uniquely identifies a person like ID number

5. Structure of data cont.

   • Table
     • Where the information is found
   • Record
     • The detail relating to a single thing or person
   • File
     • A collection of related records

6. Searching for information

   • Search engines
     • Google and others are used to search the internet for information
   • Queries
     • Used to search data bases to find a record

7. Joining operators

   • And
     • Both options
   • Or
     • One but not the other