Databases

Databases

1. Relationship

   • Microsoft Access
   • Tables
     • Records
       • Fields
   • Queries
     • Reports
       • Make it easy to show found data
       • Professional, good impression
     • Makes it easy to find fields
     • Enter criteria to find data
   • Primary key
     • No field primary key is the same
   • Data types...
     • Text
     • Number
     • Date/time
     • Currency
   • Data integrity
   • Data redundancy
   • Accuracy

2. Flat file

   • Excel
   • Spreadsheets
     • Rows
       • Letters e.g A,B,C
     • Columns
       • Numbers e.g 1,2,3
   • Formula
     • Starts with =
     • +,-.*,/
     • Functions
       • SUM
       • MIN
       • MAX
       • AVERAGE
   • Problems
     • Time consuming
     • Increase risk of mistakes
     • Data is repeated(data redundancy)
   • Formatting
     • Colours
     • Borders
     • Currency
     • Percentages
     • Date

3. Validation

4. Verification