Database-Tools and techniques

Database-Tools and techniques

1. Table characteristics

   • Rows and colums
   • Columns - fields
   • Rows-Records

2. Field types:

   • Alphabetic
     • text
     • Memo
   • Numeric
     • Numbers
     • Currency
     • Dates
     • Times

3. Validication

   • To check Erros
   • Correct format
     • Posecode
   • Applies to range
   • Check digit
     • The last one or two digits in a code are used to check the other digits are correct
   • Format check
     • Check 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

4. Records

   • Add
     • Manually
       • external source
         • Spreadsheet
   • Edit
   • Delete

5. Indexing

   • Primary key
   • foreign key

6. Relationships

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