NSC Computer Application Technology Information management: Open the 5Survey database, which

Question

Open the 5Survey database, which contains data obtained from a survey completed by visitors to Agra.

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 appears after the Surname field.
5.1.3 Create an input mask on the Code field to ensure that the user inserts a code in the required format.
NOTE: Study the data in the Code field in Datasheet View before creating the input mask.
5.1.4 A validation rule was set on the Dateln field.
Insert appropriate validation text for the Dateln field.
5.1.5 The Days field contains a calculation that attempts to determine the number of days a tourist spent in Agra.
Correct the calculation so that the days are NOT negative.
5.1.6 Change the format of the WillReturn field to 'True/False'.
Save and close the tblInfo table.

Open the frm5_2 form, based on the tblInfo table in Design View, and do the following:

- Add your examination number to the form header.
- Ensure that the Dateln field does NOT display a DatePicker in Form View.
- Insert a combo box to display the traveller types:
  - Use the options stored in table tblOptions.
  - Link the combo box to the TravellerType field.
  - Ignore the text in the label.
  - Do NOT display the page header and the page footer.

Save and close the frm5_2 form.

Open the qry5_3 query in Design View and modify it as follows:

- Display only ratings of '5'.
- Group the query on the average of the EstimateAmount field.
- Ensure that the amounts in the EstimateAmount field display TWO decimal places.

Save and close the qry5_3 query.

Open the qry5_4 query in Design View and do the following:

- 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'.

Save and close the qry5_4 query.

Open the qry5_5 query in Design View and do the following:

- Display only female tourists.
- Modify the Reaction field in the query to become a calculated field called CodeLetter. The calculated field should display the first character of the Reaction field.
- Display only the Name and Surname fields and the calculated field CodeLetter.

Save and close the qry5_5 query.

Open the rpt5_6 report in Design View and do the following:

- Remove the EstimateAmount grouping.
- Function: =Sum([EstimateAmount]) to calculate the total amount by the TravellerType group to determine the total estimated per TravellerType.
- Add a calculated field to the EstimateAmount field.

Open the 5Survey database, which contains data obtained from a survey completed by visitors to Agra - NSC Computer Application Technology - Question 5 - 2019 - Paper 1

Worked Solution & Example Answer:Open the 5Survey database, which contains data obtained from a survey completed by visitors to Agra - NSC Computer Application Technology - Question 5 - 2019 - Paper 1

5.1.1 Move the primary key set on SurveyNo field

5.1.2 Move the Name field so that it appears after the Surname field

5.1.3 Create an input mask on the Code field to ensure that the user inserts a code in the required format

5.1.4 A validation rule was set on the Dateln field

5.1.5 The Days field contains a calculation that attempts to determine the number of days a tourist spent in Agra

5.1.6 Change the format of the WillReturn field to 'True/False'

5.2 Open the frm5_2 form, based on the tblInfo table in Design View

5.3 Open the qry5_3 query in Design View

5.4 Open the qry5_4 query in Design View

5.5 Open the qry5_5 query in Design View

5.6 Open the rpt5_6 report in Design View

Join the NSC students using SimpleStudy...