Database Tools & Techniques

Database Tools & Techniques

1. Table characteristics

   • rows and columns
   • Columns=fields
     • Field types
       • Numerical data
       • Text
       • currency
       • Date
       • Web
       • Boolean
         • Yes/No
         • True/False
       • Numerical Data
     • Field Size
       • Double
       • Decimal
       • Single
       • Byte
       • Integer
       • Long integer

2. Validations

   • To check for errors
   • Applies to range
   • Correct format
     • Postcode
       • Input mask
     • Correct field size
     • Correct date type

3. Records

   • Delete
   • Add
     • Manually
     • External Source
   • Delete

4. Indexing

   • Primary key
   • Secondry Key

5. Rlationships

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