Edit the Survey_Opname table as follows:
5.1.1 Change the field size of the Type field to 10 - NSC Computer Application Technology - Question 5 - 2016 - Paper 1
Question 5
Edit the Survey_Opname table as follows:
5.1.1 Change the field size of the Type field to 10.
5.1.2 There are currently two primary keys set on the table. Remove t... show full transcript
Worked Solution & Example Answer:Edit the Survey_Opname table as follows:
5.1.1 Change the field size of the Type field to 10 - NSC Computer Application Technology - Question 5 - 2016 - Paper 1
Step 1
5.1.1 Change the field size of the Type field to 10.
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 change the field size of the Type field to 10, access the properties of the Survey_Opname table, locate the Type field, and set its 'Field Size' property to 10.
Step 2
5.1.2 Remove the unsuitable primary key from the ID 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
Review the primary keys in the table. Identify the unsuitable primary key by examining data in the ID field. Remove the one that does not provide a unique identifier, ensuring only the appropriate primary key is set for the ID field.
Step 3
5.1.3 Create an input mask on the ID field.
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
Set the Input Mask for the ID field to: >LLLLL00, which ensures users input five uppercase letters followed by one or two digits. This mask enforces the required format effectively.
Step 4
5.1.4 Correct the Protected field display.
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
Access the properties of the Protected field and update the 'Row Source Type' to 'Value List'. Ensure that 'Yes' and 'No' values are included in the drop-down list by changing its row source properties to display these values correctly.
Step 5
5.1.5 Create a new lookup field FullStatus.
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
To create a new field called FullStatus, go to the design view of the Survey_Opname table, add a new field named FullStatus, set its data type to Lookup Wizard, and source the values from the Name field of the Code_Kode table by using a SQL statement like: SELECT [Code_Kode],[Name] FROM Code_Kode.
