Databases - Tools and Techniques

Databases - Tools and Techniques

1. Table Characteristics

   • Columns=Fields
   • Rows and Columns
   • Rows=Records
   • Field Types
     • Alphabetic
       • Text
       • Memo
     • Numeric
       • Numbers
       • Currency
       • Dates
       • Time
     • Boolean/Logical
       • Yes/No
       • True/False
     • Web
       • Hyperlink
     • Lookup Wizards

2. Validation

   • To check for errors
   • Applies for a range
   • Correct Format
   • Correct Field Size
   • Correct Data Type
   • Examples
     • Check Digit
       • The last one or two digits in a code are used to check the other digits are correct
     • Format Check
       • Checks the data is in the right format
     • Length Check
       • Checks the data isn't too short or too long
     • Lookup Table
       • Looks up acceptable values in a table
     • 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

3. Records

   • Delete
   • Edit
   • Add
     • Manually
     • External Source
       • Spreadsheet

4. Indexing

   • Primary key
   • Foreign Key

5. Relationships

   • One to Many
   • Many to Many
   • One to One