Open the 5Samba database that contains details of the samba dance participants - NSC Computer Application Technology - Question 5 - 2017 - Paper 1
Question 5
Open the 5Samba database that contains details of the samba dance participants.
5.1 The results of the points for the samba dance competition are stored in the tbCo... show full transcript
Worked Solution & Example Answer:Open the 5Samba database that contains details of the samba dance participants - NSC Computer Application Technology - Question 5 - 2017 - Paper 1
Step 1
5.1.1 Change the field size of the Entry field to 15.
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
In the design view of the tbComp table, locate the Entry field. Change its field size property to 15 characters.
Step 2
5.1.2 Ensure that the data of the Entry field is inserted in the following format:
- One or two capital letter characters
- One or two digits
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
Set the input mask for the Entry field to restrict inputs to either one or two capital letters followed by one or two digits. Ensure formats like B4, A21, or A8 are acceptable.
Step 3
5.1.3 The validation rule set on the Class field does not work. Correct this validation rule by referring to the data in this field.
Provide suitable validation text.
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
Adjust the validation rule of the Class field to allow entries of 'A', 'B', 'C', 'D', 'E', and 'F'. Provide a validation message that prompts users to enter a letter from A to F.
Step 4
5.1.4 Add a field with an appropriate field name and data type for sound clips.
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
Create a new field named 'SoundClip' with a data type of 'OLE Object' suited for storing sound files.
Step 5
5.1.5 Move the Year field so that it appears as the last field in the table.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
In design view, drag the Year field to the last position in the table structure, ensuring its new position is saved.
Step 6
5.1.6 Switch to datasheet view and sort the table alphabetically according to the School field.
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Change the view to datasheet and use the sort feature to arrange entries in the School field alphabetically.
Step 7
5.2 Create a form called frm5_2 based on the tbComp table.
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
Create a new form named 'frm5_2' that includes all fields from tbComp. Include 'Entries' as the header and ensure the Class field has a combo box with the options A, B, C, D, E, and F. Display the examination number in the footer.
Step 8
5.3 Create a query qry5_3 based on the tbComp table.
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
Design the qry5_3 query to include fields for School, Surname, Name, and Position. Sort the results alphabetically by Surname and then by School, filtering to show only those who obtained first position.
Step 9
5.4 Open the qry5_4 query.
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
Filter qry5_4 to display records only from March 2 and March 3 of 2017, including only those with TotalPoints greater than 265. Add a calculated field called NewPoints that adds 10% to the TotalPoints.
Step 10
5.5 Open the qry5_5 query where the Entry number is only two characters long.
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
Configure qry5_5 to display results where the Entry field consists solely of two characters.
