Assignment Instructions

The Squirrel Monitoring System monitors and records squirrels activities in their natural habitat. They monitor mating, activities, and food sources as well as their environment particularly trees and nests. Note: 2 squirrels have been tagged with electronic devices.

Open the database monitoring.accdb and populate its tables:

• Add at least 5 records to each table except tagging only 2 squirrels are tagged.
• Ensure that some trees contain more than one nest and at least one has no nests

Develop the following queries. All queries should sort the data in a meaningful order.

1. A query listing all Untagged Squirrels.
   1. Show the squirrelID, their nickname and year of birth
   2. Sort by nickname within year of birth
2. A query of Squirrel Tagging listing all squirrels that have been tagged.
   1. Show the squirrelID, their nickname, year of birth
   2. Format the date of tagging like 23 Jan 2020
   3. Sort the records by date of tagging, most recent first.
3. A query of all activities for a given squirrel.
   1. At run time, the user is to enter the following parameters:
      1. The squirrelId
      2. The year
   2. Filter the records to the specified squirrel and activity dates in the given year
   3. Show the squirrel ID, nickname, date (formatted 23 Jan 2020), time (formatted 17:45), and the activity in words (nesting, food gathering).
   4. Sort so the most recent activity comes first.
4. A query counting the Number of Nests per tree.
   1. For each tree display the tree ID, the tree type in words (maple, oak, etc.), whether its municipal, and its nest count.
   2. Include trees without nests, specifically showing a count of 0 (zero) for these.

Develop the following forms they can be bound forms. All forms should have

• a common background colour, no dividing lines, no record selector
• a descriptive title in large font in the form header area
• a button to close the form

1. 1. A form for Squirrels that allows the user to add new Squirrels.
2. 2. A form for Trees that allows the user to add trees.
3. 3. A form for Activities that allows the user to add Activities.
4. 4. A form for Nest that allows the user to add Nests.
5. 5. Build a simple opening form with buttons that allow each form to open. This should have a picture in the background.