N5 Coursework 2018-19

Task 1a - Data dictionary

Key things to note:

• Primary and foreign keys

• Attribute data types

• Attribute validation e.g. presence check, range check, restricted choice

Task 1b - Range check

Key things to note:

• Use of the len function to make sure the length of the field is exactly six characters

e.g. len ( [username] ) = 6

Key things to note:

• Restricted choice needs a combo box to allow you to limit to list

Task 1c - SQL

Key things to note:

• You have to make your own SQL statements - don't rely on MS Access to help you!

• SELECT statements across two tables require a join - e.g. WHERE tablea.field = tableb.field

Key things to note:

• Don't overcomplicate

• Create your query in a text (NOT WORD) document before copying into MS Access

• ...

• ...