Tables

Tables

1. Characteristics

   • Rows = Records
   • Column = Fields
     • Alphabetic
       • Text
       • Memo
     • Numeric
       • Dates
       • Currency
       • Time
       • Numbers

2. Validation

   • To check for errors
   • Correct format
     • Post Code
       • Input Mask
   • Applies to a range
   • Types of validation
     • Check digit
       • The last one or two digits in a code are used to check the other digits are correct (Bar Code readers)
     • Format check
       • Checks the data is in the right format (a postcode)
     • Range check
       • Checks that a value falls within the specified range (kids in a school must be between the ages of 11 - 16)
     • Spell check
       • Looks up words in a dictionary (In word processing)
     • Presence check
       • Checks that data has been entered into a field (ensures key fields are not left blank)

3. Records

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

4. Indexing

   • Primary Key
   • Foreign Key

5. Relationships

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