Databases

3. when a key field appears in another table
4. Ensures data entered is sensible, reasonable and acceptable
7. Forces the user to enter a postcode as LL000LL
8. A database object used to present data in a professional manner.
10. The type of validation which would ensure the % entered is between 0 and 100.
13. When two fields are joined together.
15. an individual data item e.g. name
16. Forces the user to enter a date in the format DD/MM/YYYY
18. A database object used to search for data which meets specific criteria.

1. A data type that would be suitable for DOB
2. A type of validation which means fields cannot be left blank.
5. A phone number must contain 11 digits. What type of validation would ensure this?
6. The data type used to store monetary values e.g. £10.99
9. Stores data about an object/person e.g., student, book, car
11. Uniquely identifies a record.
12. Stores data items about a person, object etc.
14. A program used to carry out a number of tasks/instructions at click of a button.
16. An object use to enter data/records or view existing data.
17. A data type which can contain a combination of letters and numbers