Databases - Tools and techniques

Databases - Tools and techniques

1. Forms

2. Queries

3. Reports

4. Characteristics

   • Rows of information = Records
   • Column = Fields
   • Numeric
   • Field Types
     • Hyperlink
     • Web
     • Boolean
     • True/false
   • Validation
     • Length check
       • Checks the data isn't too short or too long (password should be 7 letters long)
     • Lookup table
       • Looks up acceptable values in a table (only 7 days in a week)
     • Format check
       • Checks the data is in the right format, a National Insurance number is in the form LL 99 99 99 L where L is any letter and 9 is any number
     • Check digit
       • The last one or two digits in a code are used to check the other digits are correct
     • Presence check
       • Checks that data has been entered into a field
     • Range check
       • Checks that a value falls within the specified range
     • Spell check
       • Looks up words in a dictionary when word processing

5. Check for errors

6. Applies to range of information

7. Correct format

   • Post code
     • Input mask

8. Records

   • Add
     • Manually
     • External source
       • Spreadsheet
   • Edit
   • Delete

9. Forms of indexing

   • Primary key
   • Foreign key

10. Relationships

    • One to many
    • One to one
    • Many to one