Information Handling Software

Information Handling Software

1. Updating, deleting and searching records

   • Update- change the data to bring up-to-date
   • Delete- remove data no longer needed
   • Search- look for specific records that match certain criteria

2. Search criteria- using operators

   • = Equals
   • > Greater Than
   • < Less Than
   • <> not equal to
   • >= Greater than or equal to
   • <= Less than or equal to

3. Joining Operators

   • Operators can be joined by AND or OR
   • Size=XL AND Type=Shirt
     • This will find all the extra large shirt details
   • Pet=Dog OR Pet=Cat
     • Will show the records of dogs or cats in the database

4. Structure of Data

   • Data- Unprocessed Information- 01012011
   • Information- Data that now has been processed and has a meaning- 01/01/2011
   • Field- An item of data or a fact- a surname=Jones
   • Record- The detail relating to a single thing or person- name, address, telephone number etc.
   • Table- Where the information is found- Rows (across) are usually the record in a database
   • File- A collection of related records- all the students in a school

5. Searching for Information

   • Search Engines- Google and others are used to search the internet for information
   • Queries- They are used to search databases to find a record