Basic (Level 1)

  • Queries
  • At least 2 different data[1] types
  • field sizes adjusted to match expectations in data
  • sensible field names
  • Customising reports and forms

Advanced (Level 2)

  • Linking related tables in the database, using keys.
  • Sorting on one field with a secondary sort on another field.
  • Creating multiple criteria queries using logical, mathematical, and/or wildcard operators.
  • SQL code for queries that do the above
  • Setting validation rules to control[2] what users can enter in a particular field (eg expressions, operators).
  • writing custom queries to filter and/or sort data
  • using logical, mathematical and/or wildcard operators
  • customising presentation of the data (reports)

Complex (Level 3)

  • CRUD
  • Data[1] sanitised AND Data validated (these are related, but different things)
  • image upload capability
  • buttons for data entry
  • Queries which modify data (insert, update or delete)
  • Creating customised input forms
  • Queries pulling data from multiple tables (e.g. SQL join)
  • Displaying joined data on webpage/report/pdf dep on outcome[3]
  • wildcard queries
Terms definitions
1. data. Raw facts or figures without context or meaning. e.g. 1, “Boris”, False
2. control. How a computer system operates or is “controlled”
3. outcome. Products and systems developed through Technological Practice for a specific purpose. A technological outcome is evaluated in terms of its fitness for purpose, and can be described by their physical and functional nature.