Database - Tools and Techniques

Database - Tools and Techniques

1. Table Characteristics

   • Rows and Columns
     • Records
       • Add
         • Manually
         • External Source
       • Edit
       • Delete
     • Rows = Records
     • Columns = Fields
     • Fields
   • Field Tyoes
     • Alphabetic
       • Text
       • Memo
     • Numeric
       • Numbers
       • Currency
       • Dates
       • Times
   • Boolean/Logical
     • Yes/No
     • True/False
   • Web
     • Hyperlink
   • Lookup Wizards
   • Field Size
     • Byte
     • Integer
     • Long Integer
     • Single
     • Double
     • Decimal
   • Fixed Formats
     • Fixed
     • Decimal Places
   • Default Values

2. Validation

   • Data Validation
   • To Check for Errors
   • Applies to a Range
   • Correct Format
     • Postcode
       • Input Mask
   • Correct Field Size
   • Correct Data Type

3. Indexing

   • Primary Key
   • Foreign Key

4. Relationships

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