ICT- Topic 8: Information handling software

ICT- Topic 8: Information handling software

1. Structure

   • Field
   • Record
   • File

2. Data type

   • Text
   • Number
   • Date
   • Time
   • AutoNumber
   • Currency
   • Boolean
   • List
   • Sound
   • Picture

3. Manipulating Data

   • Updating
   • Deleting
   • Searching
     • Single Criteria
     • Multiple Criteria
   • Sorting
     • Ascending order
     • Descending order

4. Validation

   • Range checks
   • Data type checks
   • Format checks
   • Lists
   • Input masks

5. Security issues

   • Password protection and Password protocol
   • Access rights to data
   • Backup procedures