Topic 8: Database 2

Topic 8: Database 2

1. Uses of a database

   • print out reports
   • search for particular records
   • add, change, delete records
   • sort records

2. Queries

   • simple search query
     • looks for data in one field
   • complex search query
     • looks at data with multiple criteria

3. Security

   • keeping data secure
     • access rights
     • passwords
     • back-ups
     • physical security
       • locks on doors
       • alarms
       • biometric security
   • security issues
     • for a business can lead to...
       • bad publicity
       • loss of customers
   • secure data
     • cannot be destroyed
     • cannot be altered by unauthorised people

4. Benefits

   • fast access
   • easy to edit
   • create reports
   • security