- A key field identifies a unique record in a database. it is used to make sure two people with the same name are not confused. An ID number is often used as a key field e.g. your national insurance number.
- You can set up validation checks to make sure the data you entered is correct.
- presence check- you want something to be entered.
- type check- it must be a numeric or character.
- format check-…
Similar ICT resources: