Maak die 5Tours-databasis oop - NSC Computer Application Technology - Question 5 - 2023 - Paper 1
Question 5
Maak die 5Tours-databasis oop.
5.1 Maak die tbl5_1-tabel in Ontwerpaansig ('Design View') oop.
5.1.1 Verander die eienskappe ('properties') van die IDNo soos volg:... show full transcript
Worked Solution & Example Answer:Maak die 5Tours-databasis oop - NSC Computer Application Technology - Question 5 - 2023 - Paper 1
Step 1
Verander die eienskappe ('properties') van die IDNo soos volg:
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Stel die veldgrootte in op 13 en stel dit as 'Primêre Sleutel' ('Primary Key'). Dit sal verseker dat elke ID uniek is.
Step 2
Voeg 'Safari' as 'n waardelys('value list')-opsie by die Experience-veld.
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In die veld eienskappe vir Experience, voeg 'Safari' toe aan die waardelys en verander die opsoeikens ('lookup properties') sodat 'meerdere waardes' ('Allow Multiple Values') geaktiveer is.
Step 3
Verander die eienskappe ('properties') van die Date-veld.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Stel 'n validasiereël ('Validation Rule') op wat slegs datums in die reeks van 2023/07/01 tot 2024/08/31 toelaat, deur gebruik te maak van die volgende formule: >=#2023/07/01# AND <=#2024/08/31#.
Step 4
Verander die Picture-veld soos volg:
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Stel die datatip (Object) op om 'n ID-no foto (ID photo) te aksepteer. Skuil die Picture-veld in Datasheet-ansig ('Datasheet View') om dit nie in die tabel te vertoon nie.
