Databases - tools and techniques

Databases - tools and techniques

1. Table characteristics

   • Row and columns
   • Columns = Fields
   • Rows = Records
   • Field Types
     • Alphabetic
       • Text
       • Memo
     • Numeric
       • Numbers
       • Currency
       • Dates
       • Time
     • Boolean/logical
       • Yes/No
       • True/False
     • Web
       • Hyperlink
     • Lookup Wizards
   • Field Size
     • Byte

2. Validation

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

3. Records

   • Add
     • External source
       • Spreadsheet
     • Manually
   • Edit
   • Delete

4. Indexing

   • Primary key
   • Foreign key

5. Relationships

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