Databases - Tools & Techniques

Databases - Tools & Techniques

1. Characteristics

   • Rows and columns
   • Columns = fields
   • Rows = records
   • Field types
     • Alphabetic
       • Text
       • Memo
     • Numeric
       • Numbers
       • Currency
       • Dates
       • Time
     • Boolean/ logical
     • Web
       • Hyperlink
     • Lookup wizards

2. Data validation

   • To check for errors
   • Applies to a range
   • Correct format
     • Postcode
   • Correct field size
   • Correct data type

3. Records

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

4. Indexing

   • Primary key
   • Foreign key

5. Relationships

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