4.1 Format the Classification table as follows: 4.1.1 Change the row height to the standard height 4.1.2 Ensure that gridlines are changed to red colour 4.1.3 Edit the value list for the Listed As field so that the option Threatened will be listed as the third option 4.1.4 Change the data type of Diet field to a more appropriate type 4.1.5 Ensure that the Scientific Name field is not left empty and is displayed in uppercase even if it is typed in lowercase 4.1.6 Create an input mask for the Turtle ID field to ensure that the user inserts a code made up as follows: One compulsory letter Followed by two compulsory numbers Followed by an asterisk (*) Followed by an optional digit or space Then an optional letter or digit Example: L78*1 or j89*K or k78*16 can be entered 4.2 Work with the Turtle Images table and the frm4_2 form - NSC Computer Application Technology - Question 4 - 2017 - Paper 1

Change the colour of the gridlines in the table to red for better visibility.

Edit the value list in the Listed As field, ensuring that 'Threatened' appears as the third option in the list.

Modify the Diet field to a more suitable data type, such as MEMO or Long Text, to accommodate longer entries.

Set validation rules for the Scientific Name field to prevent it from being empty, and ensure text is displayed in uppercase even if entered in lowercase.

Implement the input mask for the Turtle ID field as follows: L009a, where the structure is one compulsory letter, followed by two compulsory numbers, an asterisk (), an optional digit or space, and then an optional letter or digit.

Resolve the issue by ensuring that the image 'Green Sea Turtle.jpg' is correctly linked and displayed in the frm4_2 form.

Export the Turtle Images table as a PDF file, naming it 'Export4_2' and saving it in the specified examination folder.

Filter the query to show records where total species count is 399 or less and whose diet includes both 'jelly fish' and 'crab'.

Create a new query displaying the Turtle Name and Colour, with an additional calculated field for 'Weight in pounds', calculated by:

ext{Weight in pounds} = rac{ ext{Weight (kg)}}{2.2046}

Round the weight to one decimal place and filter to show names starting with letters between G and O, sorted in ascending order of their names.

Modify the form by adding a border width of 4pt, applying a shadow effect to the image, inserting a command button for form exit, ensuring dividing lines are invisible, and changing the default view to continuous.

Generate the report to display fields: Turtle Name, Turtle ID, Colour, Weight (in kg), and Listed As, with grouping by Weight in kg set to intervals of 50s. Ensure this report doesn't display on the first page and add a calculation to count the number of 'Critically Endangered' turtles with a proper label.