Databases Tools & techniques

Databases Tools & techniques

1. Characteristics

   • Columns = Fields
   • Field Type
     • Alphabetic
       • Memo
       • Text
     • Numeric
       • Numbers
       • Currency
       • Dates
       • Time
     • Boolean/Logical
       • Yes/No
       • True/False
     • Web
       • Hyperlink
     • Lookup Wizards
   • Field size
     • Byte
     • Integar
     • Long Integar
     • Single
     • Double
     • Decimal
   • Rows = Records
   • Field Formats
     • Fixed
     • Decimal Places
   • Default Values

2. Vaildation

   • To check for errors
   • Applies to a range
   • Correct Format
     • Post Code
       • Input Mask
   • Correct Field Size
   • Correct data type
   • examples
     • Presence Check
       • Check that something has entered the field (It can't be blank)
     • Lookup Table
       • Looks up right values for a table (Only seven days in a week)
     • Length check
       • Check what is entered isn't too short or too long (Password needs to be more than 6 characters)
     • Format check
       • Check the data is in the right format (Postcode)
     • Check digit
       • Last two digits of the code are used to make sure it is all correct
     • Range Check
       • Checks that a value falls within a range (Between 10 and 50 hours a week)
     • Spell Check
       • Look up words (Using Word)

3. Records

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

4. Indexing

   • Primary Key
   • Foreign Key

5. Relationships

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