5.1 Edit the tblInfo table in Design View as follows:
5.1.1 Move the primary key from the Code field to the SurveyNo field - NSC Computer Application Technology - Question 5 - 2019 - Paper 1
Question 5
5.1 Edit the tblInfo table in Design View as follows:
5.1.1 Move the primary key from the Code field to the SurveyNo field.
5.1.2 Move the Name field so that it ap... show full transcript
Worked Solution & Example Answer:5.1 Edit the tblInfo table in Design View as follows:
5.1.1 Move the primary key from the Code field to the SurveyNo field - NSC Computer Application Technology - Question 5 - 2019 - Paper 1
Step 1
5.1.1 Move the primary key from the Code field to the SurveyNo field.
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
To move the primary key to the SurveyNo field, open the tblInfo in Design View, click on the Code field, and change the Primary Key setting to the SurveyNo field. Ensure the SurveyNo field is selected and save the changes.
Step 2
5.1.2 Move the Name field so that it appears after the Surname field.
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 the tblInfo Design View, locate the Name field and drag it down to position it immediately after the Surname field. Save the design.
Step 3
5.1.3 Create an input mask on the Code field to ensure that the user inserts a code in the required format.
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
Select the Code field in Design View. In the properties section, set the Input Mask property to '>">L0000"', which ensures that the code starts with a letter followed by four digits, and is displayed in uppercase.
Step 4
5.1.4 A validation rule was set on the Dateln field.
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
For setting the validation rule in the Dateln field, open the field properties and enter the validation rule to ensure dates entered are between '2017/12/31' and '2019/10/10'.
Step 5
Insert appropriate validation text for the Dateln field.
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
Enter a validation text such as 'Please enter a valid date within the range of 31/12/2017 to 10/10/2019' to guide users.
Step 6
5.1.5 The Days field contains a calculation that attempts to determine the number of days a tourist spent in Agra.
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
To correct the calculation for the Days field, set the formula to 'Abs([DateOut]-[Dateln])' so that it always returns a positive number.
Step 7
5.1.6 Change the format of the WillReturn field to 'True/False'.
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 tblInfo, set the Format property of the WillReturn field to 'True/False'.
Step 8
5.2 Add your examination number to the form header.
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
Open frm5_2 in Design View and insert a label in the form header area to display your examination number.
Step 9
5.2 Ensure that the Dateln field does NOT display a DatePicker in Form View.
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
Select the Dateln field in frm5_2 and change the property to disable the DatePicker feature in Form View.
Step 10
5.2 Insert a combo box to display the traveller types.
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
Add a combo box to the frm5_2 form, and set its Row Source to query the tblOptions allowing the selection of traveller types.
Step 11
5.3 Display only ratings of '5'.
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 qry5_3, set the criteria for ratings to '5' in the relevant field.
Step 12
5.3 Group the query on the average of the EstimateAmount 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 grouping option in qry5_3 to group on the average of the EstimateAmount field.
Step 13
5.3 Ensure that the amounts in the EstimateAmount field display TWO decimal places.
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 qry5_3, change the format of the EstimateAmount field to ensure that it displays two decimal places.
Step 14
5.4 Display the records of the tourists whose Code starts with the letter 'S' and ends with the number 0; and Reaction was anything other than 'Unmoved'.
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 criteria in qry5_4 to filter records where the Code field starts with 'S' and ends with '0'. Additionally, set criteria on the Reaction field to exclude 'Unmoved'.
Step 15
5.5 Display only female tourists.
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
In qry5_5, add a criterion to filter results where the Gender field equals 'Female'.
Step 16
5.5 Modify the Reaction field in the query to become a calculated field called CodeLetter.
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
In qry5_5, create a calculated field called CodeLetter which extracts the first character of the Reaction: 'Left([Reaction],1)'.
Step 17
5.5 Display only the Name and Surname fields and the calculated field CodeLetter.
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
Adjust qry5_5 to show only the Name, Surname, and newly created CodeLetter fields.
Step 18
5.6 Remove the EstimateAmount grouping.
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
Open rpt5_6 and delete the grouping related to the EstimateAmount field.
Step 19
5.6 Add a control to display the EstimateAmount field.
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
Insert a control in rpt5_6 to show the total EstimateAmount, ensuring it reflects the data correctly.
