Untitled

Enter text here

1. data capture

   • design
     • simple
     • easy to use
     • not too long
     • not boring
     • provides clear instructions
     • logically laid out
     • has spaces to be filled in
     • what to do
   • any form that appears on screen should:
     • adjustable for different screens
     • not be cluttered
     • relevant information
     • suitable font
     • images in suitable places
     • not use colours that are difficult to see
     • suitable background colours

2. key terms

   • a row is a record
     • the top record are called field names
   • records contain fields
     • fields are individual cells
   • primary key
     • data to uniquely identify each record
   • foreign key

3. data types

   • text
     • allows numbers and letters
   • numerical
     • only numbers
   • boolean
     • allows one of two options
   • date/time
     • date or time
   • autonumber
     • computer generates a unique number
   • integer
     • whole number
   • real number
     • any number
   • currency
     • price

4. validation

   • range checks
     • checks data is within a range
   • type checks
     • checks type of data
   • format checks
     • date of birth