Work in groups.

Once again, for this activity you will need Microsoft Access.

1. Create a folder on the C: drive or your memory stick to contain your homework assignments for ISP 121.
   Name it something like isp121-smith, where smith is your last name.

2. Download the (updated) access file 121class.mdb and save it in your isp121-smith folder.

3. Open the 121class.mdb database (click or double-click on it). If there is a security warning, select open to open the database.

   Open the tables tblStudents, tblPets, and tblSiblings in the DB 121class.mdb. Examine the fields and records, both in Design view and Datasheet view. Note any primary keys and foreign keys. 

4. Queries:
   1. Which siblings over the age of 19 still live at home?
      Only show sibling name and age.

   2. List all siblings, males first. Within Gender list LiveAtHome's first.
      Only show SibFirstName, Gender, LiveAtHome.

   3. Which students own a dog that's not a mutt?
      Only show student's new first name, dog's name, dog's breed.

   4. Find the average age of each gender of siblings.

   5. Display a table containing the number of each pet Type.

   6. How many of each breed of dog are there?
      Show a table displaying only Breed and count.

   7. How many siblings are 22 years old? Show only the number.

   8. Find the average age of the cats and dogs (only the cats and dogs).

5. Requirements:
   • Your eight queries in part 4 above, must be named Q1,...,Q8.
     
   • Your database file must be called A3-Smith-Jones-Fritz.mdb, where Smith, Jones, Fritz are your last names.
   • Double check that your database file opens properly and contains your eight queries.
   • Submit your A3-Smith-Jones-Fritz.mdb file using COLweb.