Databases- tools and techniques

Databases- tools and techniques

1. Table characteristics

   • Rows and columns
   • columns=fields
   • rows=records
   • field types
     • text
     • numbers
     • currency
     • dates
     • time
     • Boolean
       • yes/no
       • True/ false
   • web
     • hyperlink
     • look up wizard
   • field size
     • byte
     • integer
     • long integer
     • single
     • double
     • decimal

2. field formats

   • fixed
   • decimal places

3. default values

4. validation

   • to check for errors
   • applies to a range
   • correct format
   • correct field size
   • correct data type

5. records

   • delete
   • edit
   • add
     • Manually
     • external source
       • spread sheet

6. indexing

   • primary key
   • foreign key

7. Relationships

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