5.1 Edit the tbJewellery table as follows: 5.1.1 Change the field size of the Metal field to 33 - NSC Computer Application Technology - Question 5 - 2016 - Paper 1

Format the Stones field to allow for a Yes/No type. This can typically be achieved by setting the format property to a Yes/No data type or a boolean format.

Configure the Grams field with the following properties:

• Set the 'Required' property to Yes, ensuring that the user must input a value.
• Use a Validation Rule to restrict entries to between 11 and 80. The rule can look like: >10 AND <=80.
• Provide an appropriate validation message such as 'Please enter a value between 11 and 80.'

Edit the JewelleryType field options to:

• Remove the 'Watch' option.
• Add 'Bangle' as the second option in the list. The final order should be:
  1. Ring
  2. Bangle
  3. Earrings
  4. Bracelet
  5. Necklace.

Set up an input mask for the JewelleryId field to enforce the format:

• Use 'LLL000' where 'L' represents a letter and '0' represents a digit. This allows for three letters, one letter or digit, and one or two digits at the end.

To set the ValuationDate default value, utilize a formula that adds 60 days to the current date. This can be set as:

DATEADD(day, 60, GETDATE())

This SQL function will calculate the date that is 60 days later than today.