Photo AI
5.1 Redigeer die Learners_Leerders-tabiel soos volg: 5.1.1 Stel die versteekwaarde ('default value') van die Gender_Geslag-veld op 'M' - NSC Computer Application Technology - Question 5 - 2016 - Paper 1
Question 5
5.1 Redigeer die Learners_Leerders-tabiel soos volg: 5.1.1 Stel die versteekwaarde ('default value') van die Gender_Geslag-veld op 'M'. 5.1.2 Verander die kenmerke... show full transcript
Worked Solution & Example Answer:5.1 Redigeer die Learners_Leerders-tabiel soos volg: 5.1.1 Stel die versteekwaarde ('default value') van die Gender_Geslag-veld op 'M' - NSC Computer Application Technology - Question 5 - 2016 - Paper 1
Step 1
5.1.1 Stel die versteekwaarde ('default value') van die Gender_Geslag-veld op 'M'.
Answer
To change the default value of the Gender_Geslag field to 'M', access the Learners_Leerders table properties. Locate the Gender_Geslag field and set the default value property to 'M'. This ensures that whenever a new record is created, the Gender_Geslag field will automatically be set to 'M' unless specified otherwise.
Step 2
5.1.2 Verander die kenmerke ('properties') van die Grade_Graad-veld om te verseker dat 'n gebruiker 'n waarde in die veld moet insleutel.
Answer
To ensure a user must enter a value in the Grade_Graad field, modify its properties. Set the 'Required' property to 'Yes', which enforces that this field cannot be left empty when a record is submitted. This is critical for maintaining data integrity.
Step 3
5.1.3 Verander die kenmerke ('properties') van die Class_Klas-veld om die volgende ander opsies in 'n afkleks ('drop-down list') te vertoon: A B C D
Answer
To modify the Class_Klas field to present a drop-down list with specific options, access the field properties and set the 'Row Source' property. Input the values A, B, C, and D in the source. This allows users to select from predefined options, ensuring standardized entries.
Step 4
5.1.4 Verander die DOB_Geboortedatum-veld soos volg: - Formateer die veld om die datums in medium datum-formaat ('Medium Date') te vertoon. - Voeg 'n toegangsmaskeer ('input mask') in om die '#'–simbool in plaas van die '?'–simbool as 'n plekhouer te vertoon.
Answer
To format the DOB_Geboortedatum field, change its property to 'Medium Date'. Then, apply an input mask that replaces '?' with '#'. This means that the user will see the '#' symbol as a placeholder, guiding them to enter a date in the specified format. This enhances user experience and data accuracy.
Step 5
5.1.5 Skep 'n valideringsreël ('validation rule') vir die Cell_SEL-veld sodat die gebruiker presies 10 karakters (van enige tipe) in dié veld moet insleutel.
Answer
Create a validation rule for the Cell_SEL field to ensure exactly 10 characters are entered. The rule can be set as follows: 'LEN([Cell_SEL])=10'. This ensures that the user cannot submit the form unless they enter precisely 10 characters, maintaining data uniformity.