Open the Dam table - NSC Computer Application Technology - Question 5 - 2017 - Paper 1
Question 5
Open the Dam table.
5.1.1 Insert a primary key on the most appropriate field.
5.1.2 Ensure that any data currently stored in the Town field will appear in capital ... show full transcript
Worked Solution & Example Answer:Open the Dam table - NSC Computer Application Technology - Question 5 - 2017 - Paper 1
Step 1
5.1.1 Insert a primary key on the most appropriate 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 insert a primary key, identify the field that uniquely identifies each record. In this case, the Name or Location field can be set as the primary key since it is likely to be unique for each dam. Use the table design view to set this property.
Step 2
5.1.2 Ensure that any data currently stored in the Town field will appear in capital letters.
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
To ensure data in the Town field is in capital letters, set the input mask or use a validation rule that formats all entries in uppercase automatically. This can typically be done in the field properties by setting the 'Format' to 'Uppercase'.
Step 3
5.1.3 Add a combo box to the Province 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
To add a combo box to the Province field, change the field type to a combo box in the table design view and set the row source to pull values from the Province table. This will allow users to select from a list of provinces.
Step 4
5.1.4 Create an input mask for the Completed field to accept dates.
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 the table design view, set the input mask for the Completed field to '00/LLL/0000'. This will ensure that dates are entered in the specified format of 'dd/MMM/yyyy'. Additionally, proper error messages should be configured to guide users if they input incorrect formats.
Step 5
5.1.5 Change the field properties of the Capacity 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
To ensure the Capacity field accepts only valid values, set the 'Validation Rule' to '>=0'. This rule will prevent users from entering negative values, ensuring data integrity.
Step 6
5.1.6 Change the data type of the Illustration 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 data type of the Illustration field to 'OLE Object' or 'Hyperlink' to allow image files to be linked or embedded. This can be done in the table design view by selecting the appropriate data type for that field.
Step 7
5.2 Open the qry5_2 query.
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 query design, insert the Town field and filter the results to show only those records where the Province field is set to 'Limpopo'. Ensure that the query is correctly saving and will display the specified details.
