Information handling software

Information handling software

1. Information handling software

   • Any software used to store, manipulate and output information
   • Covers
     • Database software
     • Databases created using spreadsheet software
     • Stores of music, sounds, photographs

2. Updating, deleting and searching records

   • Update
     • Change the data
   • Delete
     • Remove data not needed
   • Search
     • Look for specific records

3. Search criteria

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

4. Joining operators

   • Can be joined by 'AND' or 'OR'
     • e.g. size=XL 'AND' type=shirt
       • Then will find all extra large shirt details

5. Structure of data

   • Data
     • Unprocessed information
       • e.g. 01012011
   • Information
     • Processed data
       • e.g. 01/01/20111
   • Field
     • Data or a fact
       • e.g. a surname - Jones

6. Structure of data cont

   • Record
     • Detail relating to a single thing or person
       • e.g. name/address/number
   • Table
     • All information is kept
   • File
     • Collection of related records
       • e.g. all students in a school

7. Searching for information

   • Search engines
     • e.g. google
   • Queries
     • Used to search databases to find a record

8. The ID or club number in a database is a key field, this is because it is uniquely identified

9. Information handling software

   • Any software used to store manipulated and output information
   • Covers
     • Database software
     • Databases created using spreadsheets software
     • Stores of music, sounds and photographs