Database Tools & Techniques: Tables

Database Tools & Techniques: Tables

1. Table Characteristics

   • Rows And Columns
   • Columns = Fields
     • Field Types
       • Text
       • Numerical Data
       • Boolean
         • Yes/No
         • True/False
       • Currency
       • Date
       • Time
       • Web
         • Hyperlinks
     • Field Size
       • Integer
       • Long Integer
       • Single
       • Decimal
       • Byte
       • Double
   • Records
     • Add
       • Manually
       • External Source
     • Edit
     • Delete
   • Field Formats
     • Decimal Values
     • Fixed

2. Validation

   • To check for errors
     • Spell Check
       • Check words are spelt correctly when word processing
     • Presence Check
       • Check that something is inputted; most fields cant be left blank
     • Check Digit
       • Use the last digit to check the rest are acceptable e.g. barcode sanners
   • Applies to a range
     • Range Check
       • Check that a value is within a given range
   • Correct format
     • Postcode
     • Input mask
     • Format Check
       • Checks the data is in the correct format e.g. dates must be in dd/mm/yy
   • Correct field size
   • Correct data types
     • Lookup Table
       • Finds acceptable values from a lookup table
     • Length Check
       • Inputted data must be of a certain size e.g. passwords must be at least 7 digits.

3. Indexing

   • Primary Key
   • Foreign Key

4. Relationships

   • One To One
   • Many To Many
   • Many To One