Photo AI
Edit the Learners_Leerders table as follows: 5.1.1 Set the default value of the Gender_Geslag field to 'M' - NSC Computer Application Technology - Question 5 - 2016 - Paper 1
Question 5
Edit the Learners_Leerders table as follows: 5.1.1 Set the default value of the Gender_Geslag field to 'M'. 5.1.2 Change the properties of the Grade_Graad field to ... show full transcript
Worked Solution & Example Answer:Edit the Learners_Leerders table as follows: 5.1.1 Set the default value of the Gender_Geslag field to 'M' - NSC Computer Application Technology - Question 5 - 2016 - Paper 1
Step 1
5.1.1 Set the default value of the Gender_Geslag field to 'M'.
Answer
To set the default value of the Gender_Geslag field to 'M', open the design view of the Learners_Leerders table. Select the Gender_Geslag field and in the properties pane, find the Default Value property. Enter 'M' in this field and save the changes.
Step 2
5.1.2 Change the properties of the Grade_Graad field to ensure that a user has to enter a value in this field.
Answer
In the design view of the Learners_Leerders table, select the Grade_Graad field. Change the 'Required' property to 'Yes' to ensure that a user must enter a value in this field before the record can be saved.
Step 3
5.1.3 Change the properties of the Class_Klas field to display the following four options in a drop-down list: A, B, C, D.
Answer
Select the Class_Klas field in the design view. Change the Display Control property to 'Combo Box'. In the Row Source property, enter the values A, B, C, and D as options. This will create a drop-down list for the Class_Klas field.
Step 4
5.1.4 Change the DOB_Geboortedatum field as follows: - Format the field to display the dates in the Medium Date format. - Add an input mask to display the '#' symbol as a placeholder instead of the '_' symbol.
Answer
For the DOB_Geboortedatum field, set the Format property to 'Medium Date' to display dates appropriately. Then, for the Input Mask property, create an input mask that uses the pattern '00/00/0000;0;#' to display the '#' symbol as a placeholder.
Step 5
5.1.5 Create a validation rule for the Cell_Sel field so that the user has to enter exactly 10 characters (of any type) in this field.
Answer
In the design view, select the Cell_Sel field and find the Validation Rule property. Enter the rule as Len([Cell_Sel])=10. Additionally, set the Validation Text property to inform users that they must enter exactly 10 characters.