To Activities

ISP 121 -- Activity A1

Filtering and Sorting

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

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

3. Open the tblStudents table in 121class.mdb and use filtering and sorting to answer the following:
   1. Sort (ascending) the tblStudents table by Major.

   2. Show all students that are NOT Communications majors.

   3. Show the Psychology majors that made a New Years resolution.

   4. Show only students with Major Communications and made a New Year resolution
      or Psychology Major and did not make a New Year resolution. Sort by Major.

   5. Sort the tblPets table by age.

   6. In the tblPets table, show all Labrador Retrievers over 5 years old (sorted by Name).

4. Requirements:
   • Each group will submit one Word document containing the six answers for parts a-f given in 3 above.
     
   • Each of your six answers will need to be copied and pasted into your Word document.
   • All group member names must be listed at the top of your Word document.
   • The name of your Word document must be according to the usual convention.
     Example: A1-Debnar-Moran-Schroeder.doc
   • Submit your Word document using COLweb.