MIS 388
Access Homework
Crystal Tigers is a service club with about 150 members. The club primarily sponsors events such as community pancake breakfasts, local concerts, sporting competitions, dances, etc. The club successfully uses the events to raise money for various charitable organizations. The club needs a database to help track the roles of the various members, both in terms of positions they have held within the organization and their work at the fund raising events. The following form is what they are currently maintaining on each member:
|
Last name, first name Phone Street address City, state, zip |
Year |
Position |
Comments |
||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Event title Start date, end date Charity Charity contact, phone Amount raised |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Event title Start date, end date Charity Charity contact, phone Amount raised |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Event title Start date, end date Charity Charity contact, phone Amount raised |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Event title Start date, end date Charity Charity contact, phone Amount raised |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
Assignment:
|
Taylor, David 936-555-1111 123 |
Year |
Position |
Comments |
||
|
2000 |
President |
Excellent |
|||
|
2001 |
Secretary |
Magnificent |
|||
|
2002 |
Treasurer |
He is unbelievable |
|||
|
|
|
|
|||
|
|
|
|
|||
|
Road Kill Roundup 6/15/2003 6/30/2003 Habitat for Animals Catherine Jones 281-555-2222 $575.00 |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
6/30/2003 |
4 |
Counting cash |
|||
|
|
|
|
|||
|
|
|
|
|||
|
Let’s Get Wet 3/1/2004 3/30/2004 Save the Whales Captain Ahab 281-555-5555 $1,750.00 |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
3/15/2004 |
5 |
Crepe paper |
|||
|
|
|
|
|||
|
|
|
|
|||
|
Help the Homeless 2/1/2004 2/15/2004 Disabled Teachers Fred Jones 281-555-1111 $900.00 |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
1/15/2004 |
2 |
Painting |
|||
|
1/16/2004 |
5 |
decorating |
|||
|
2/1/2004 |
8 |
Setting up |
|||
|
Help the Homeless 2/1/2004 2/15/2004 Disabled Teachers Fred Jones 281-555-1111 $900.00 |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
2/15/2004 |
10 |
Working hard |
|||
|
|
|
|
|||
|
|
|
|
|||
|
Smith, John 936-555-2222 124 |
Year |
Position |
Comments |
||
|
2003 |
Treasurer |
Stole us blind |
|||
|
2004 |
Vice Pres |
Not much good |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Help the Homeless 2/1/2004 2/15/2004 Disabled Teachers Fred Jones 281-555-1111 $900.00 |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
2/1/2004 |
5 |
Setting posts |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Jones, Sam 936-555-3333 125 |
Year |
Position |
Comments |
||
|
2004 |
Historian |
dud |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Let’s Get Wet 3/1/2003 3/30/2003 Save the Whales Captain Ahab 281-555-5555 $1,500.00 |
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
1/1/2003 |
10 |
Doing something |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
Member Activities for Event |
||||
|
Date |
Hours |
Comments |
|||
|
|
|
|
|||
|
|
|
|
|||
|
|
|
|
|||
|
Jones, Sandra 936-555-3333 125 |
Year |
Position |
Comments |
||
|
|
|
|
|||
|
|
|
||||