Information Handling Software

Information Handling Software

1. Updating, Deleting and Searching Records

   • Updating - change data to bring it up to date
   • Delete - remove data no longer needed
   • Search - look for specific records (e.g. year 11 students)

2. Search Operators

   • = equal to
   • > greater than
   • < less than
   • <> not equal to
   • >= greater than or equal to
   • <= less than or equal to

3. Joining Operators

   • AND
     • Results that include both criteria
     • Size = XL AND Type = Shirt
       • Shows results for XL shirts
   • OR
     • Both results for either criteria
     • Size = XL OR Type = Shirt
       • Shows results for all XL items and all Shirts

4. Structure of Data

   • Data - unprocessed information
   • Information - data with meaning
   • Field - an item of data/ a fact - e.g. Surname (Jones)
   • Record - e.g. Name, Address, Telephone Number
   • Table- where information is found
   • File - a collection of related records

5. Searching for Information

   • Search Engines
     • e.g. Google
     • used to search the internet for information
   • Querieas
     • used to search databases for records