NSC Computer Application Technology Information management: 5.1 Change the tbl5_1 table as f

Question

5.1 Change the tbl5_1 table as follows:

5.1.1 Change the Indexed field property of the TSurname field to allow for duplicate values.

5.1.2 Display the date in the TBirthDate field in the Short Date format.

5.1.3 Change the TAge field properties to display the age without decimals.

5.1.4 Set the field properties of the EContact field so that the user can only enter text that contains an '@' sign.

5.1.5 Set the TType field to an appropriate field size.

5.1.6 Create an input mask for the user to enter data in the following format:
- Lowercase letters
- The first character is a full stop (.), followed by
- TWO compulsory letters, followed by
- ONE optional letter

NOTE: The full stop must display when a record is selected.

5.1.7 Centre the content of the PyramidCode field.

5.1.8 Create a combo box for the PyramidSite field by using the tblSites table.

5.1.9 Switch to Datasheet View.

Insert the 5Andrews picture found in your examination folder in the TPhoto field for the traveller 'Andrews Peter'.

Save and close the tbl5_1 table.

5.2 Open the form called frm5_2 in Design View and do the following:
- Change the order of the fields to TSurname, TName, EContact and TPhoto.
- Replace the heading in the form header with your examination number.
- Insert the Date field in the form header.
- Shade the EContact field to any colour of your choice.

Save and close the frm5_2 form.

5.3 Open the qry5_3 query in Design View.

Modify the query so that it displays the total number of pyramids at the Giza site.

Save and close the qry5_3 query.

5.4 Open the qry5_4 query in Design View and do the following:
- Sort the query first according to the Surname field and then according to the Name field.
- Display the records of those visitors who were born before 1960 and whose domain type is 'org' or 'edu'.
- Tourists receive a 15% discount on the visitors' cost (VisitorsCost).
Insert a calculated field called Payable to determine the amount payable after the discount has been deducted.

Save and close the qry5_4 query.

5.5 Create a report named rpt5_5, based on the tblVisitors table, to display the records as follows:
- Take note of the following:
  - The fields that display
  - Grouping
  - A calculation
  - The format of the VisitorsCost field.

5.1 Change the tbl5_1 table as follows: 5.1.1 Change the Indexed field property of the TSurname field to allow for duplicate values - NSC Computer Application Technology - Question 5 - 2020 - Paper 1

Worked Solution & Example Answer:5.1 Change the tbl5_1 table as follows: 5.1.1 Change the Indexed field property of the TSurname field to allow for duplicate values - NSC Computer Application Technology - Question 5 - 2020 - Paper 1