Topic 8- Information-Handling Software

Topic 8- Information-Handling Software

1. Database is organised collection of data

   • Allows to find information quickly and easily
   • Benefits of using database:
     • Fast access
     • Easy editing
     • Validation
     • Production of reports
     • Security
     • Can share the data

2. With a database you can:

   • Add new data
   • Change or delete data
   • Search the data
   • Sort data into order

3. Key field uniquely identifys records

   • Can be validated by:
     • Range check
     • Type check
     • Length check
     • Lookup list
     • Presence check
     • Input mask
     • Validation ensures reasonible data is inputted onto the computer

4. Data types allow the computer to process a variety of different sorts of data:

   • Number (integer)
   • Number (real)
   • Date/time
   • Currency
   • Picture
   • Sounds
   • Video
   • Lists

5. Physical methods of security include:

   • Locks on doors
   • Alarms
   • ID cards
   • Biometric systems (fingerprint recognition, voice recognition)

6. A field is an individual data item within a record

7. Data is stored on hard drives of computers, so it is important that computers and data are kept safe

8. Search criteria of a query consists of field names and values being seached for