Open the 5Animals database that contains information about the animals in the zoo and the measures taken to protect their physical and emotional wellbeing - NSC Computer Application Technology - Question 5 - 2024 - Paper 1
Question 5
Open the 5Animals database that contains information about the animals in the zoo and the measures taken to protect their physical and emotional wellbeing.
5.1 Edit... show full transcript
Worked Solution & Example Answer:Open the 5Animals database that contains information about the animals in the zoo and the measures taken to protect their physical and emotional wellbeing - NSC Computer Application Technology - Question 5 - 2024 - Paper 1
Step 1
5.1.1 Set a property to the KeeperName field that will make sure a zookeeper is always assigned to an animal enclosure.
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 the tbl5_1 table, select the KeeperName field. Set the 'Required' property to 'Yes' to ensure that a zookeeper must be assigned to each animal enclosure.
Step 2
5.1.2 Change the Time field to accept values in the 00:00 time format.
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
Select the Time field and change the 'Data Type' to 'Date/Time'. Set the 'Format' property to 'Short Time' which ensures time values are displayed in the 00:00 format.
Step 3
5.1.3 Set the properties of the Enclosure field so that it will display a message as shown below, should incorrect information be entered.
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
For the Enclosure field, set 'Validation Rule' to '"Habitat" Or "Exhibit"' to allow only these values. Then provide a 'Validation Text' stating 'Only Habitat or Exhibit' that will prompt users if invalid information is entered.
Step 4
5.1.4 Create an input mask on the AccessCode field to accept data as follows
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
On the AccessCode field, set the 'Input Mask' to L"0000"C to enforce the required format: a letter followed by '@' and the last four digits of a cellphone number followed by any optional character.
Step 5
5.1.5 Delete the field NextFeed.
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 Design View of tbl5_1, select the NextFeed field and delete it to remove the unnecessary data field.
Step 6
5.2.1 Modify the Group field so that it displays as follows.
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
In the frm5_2 form Design View, adjust the Group field's 'Row Source' to include the options 'Carnivore', 'Herbivore', 'Omnivore', and set the Row Source Type to 'Value List' to present these choices in a dropdown.
Step 7
5.2.2 Insert a formula in the textbox in the form header, to determine whether an animal's lifespan is more than the average.
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 textbox in the form header, use the formula =[Lifespan]>25 to compare the lifespan of the animal to the average of 25 years. Format the textbox to display results in a Yes/No format.
Step 8
5.3 Modify the query to create a list of all the animals that originated from Africa and belong to the 'Carnivore' group.
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 qry5_3 query Design View, set criteria to filter the 'Origin' field for 'Africa' and the 'Group' field for 'Carnivore'. Select the 'Animal' and 'Status' fields to display in the results.
Step 9
5.4 Modify the query to display a list of animals with specific criteria.
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
For qry5_4, apply filters: Set 'Status' criteria to 'Endangered', 'Lifespan' to '<20 OR <19', and 'Population' to 'Is Null'. Use OR and AND logic correctly in the criteria.
Step 10
5.5 Display the average lifespan of animals according to their group.
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, select average lifespan and ensure the 'Group' field totals are displayed. Format the Lifespan field Totals row to 'Avg' using the standard formatting option to show ONE decimal place.
Step 11
5.6 Create a report named rpt5_6.
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 the rpt5_6 report, include Animal, Status, Behaviour, and Adapt fields, ensuring to incorporate the 5ZooLogo image and format the Group field border.
