Databases-Tools and Techniques

Databases-Tools and Techniques

1. Table characteristics

   • Rows and columns
   • Columns = feilds
   • Rows = records
   • field types
     • Alphabetic
       • Text
       • Memo
     • Numeric
       • Numbers
       • Currency
       • Dates
       • Time
     • Boolean/logical
     • Web
       • Hyperlink
     • Lookup wizard

2. Data validation

   • Check for errors
   • Applies to a range
   • Correct format
     • Postcode
       • input mask
   • 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
   • One to one
   • Many to many