Database - Tools and Techniques

Database - Tools and Techniques

1. Table characteristics

   • Rows and columns
     • Rows = Records
     • Columns = Fields
       • Alphabetic
         • Text
         • Memo
       • Numeric
       • Boolean/Logical
       • Web
       • Look up wizard
       • Field size
       • Field size
       • Field format
       • Web
         • Hyperlink

2. Validation

   • To check for errors
   • Applies to a range
   • Correct format
     • postcode
       • input mask
   • Correct field size
   • Correct data size

3. Indexing

   • Primary key
   • foreign key

4. Relationships

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