Photo AI
5.1 Open the tbl5_1 table in Design View - NSC Computer Application Technology - Question 5 - 2023 - Paper 1
Question 5
5.1 Open the tbl5_1 table in Design View. 5.1.1 Modify the properties of the IDNo field as follows: - Set an appropriate field size. - Set the field properties so t... show full transcript
Worked Solution & Example Answer:5.1 Open the tbl5_1 table in Design View - NSC Computer Application Technology - Question 5 - 2023 - Paper 1
Step 1
5.1.1 Modify the properties of the IDNo field as follows:
Answer
To modify the IDNo field, first, open the table in Design View. Set the field size to 13, ensuring it can accommodate the ID numbers. Additionally, set the field property to make sure that the IDNo field is a Primary Key, which will uniquely identify each record in the table.
Step 2
5.1.2 Add 'Safari' as a value list option to the Experience field.
Answer
To add 'Safari' as a value option to the Experience field, navigate to the Experience field properties and select the option to add a new value. Make sure to adjust the settings to allow for multiple selections, ensuring tourists can pick more than one experience type.
Step 3
5.1.3 Change the properties of the Date field to only accept dates from the beginning of July 2023 to the end of August 2024.
Answer
For the Date field, set the validation rule to restrict the accepted entries to dates between July 1, 2023, and August 31, 2024. The validation rule could look like this: >=#2023/07/01# AND <=#2024/08/31#. Additionally, set the validation text to display a user-friendly message if the entered date falls outside this range.
Step 4
5.1.4 Change the Picture field as follows:
Answer
To change the Picture field, first, set an appropriate data type that allows for image uploads, typically an 'OLE Object'. Move this field so it appears beneath the IDNo field in the table layout. Then, change the displayed title in Datasheet View to 'IDphoto' instead of 'Picture' while ensuring the original field name remains unchanged.
Step 5
5.1.5 Change the colour of the gridlines to black AND set the option to display only the horizontal gridlines.
Answer
Switch to Datasheet View to adjust the gridline colors. In the table properties, change the gridlines color to black and ensure you set the display option to show only horizontal gridlines, eliminating vertical lines for a cleaner look.