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:

1. Analyze the form and determine the database tables and relationships that would be required.
2. Use the following data to populate your tables:

Taylor, David 936-555-1111 123 Main Huntsville, TX 77341	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 Main Huntsville, TX 77341	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 Main Huntsville, TX 77341	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 Main Huntsville, TX 77341	Year	Position		Comments
	Member Activities for Event
	Date		Hours		Comments
	Member Activities for Event
	Date		Hours		Comments
	Member Activities for Event
	Date		Hours		Comments

Anderson, Pamela 936-555-1111 123 Main Huntsville, TX 77341	Year	Position		Comments
	2002	President		Okay job
Aim Straight 1/1/2003 12/31/2003 NRA Charleton Heston 281-555-3333 $500.00	Member Activities for Event
	Date		Hours		Comments
	7/1/2003		3		Fixing stuff
Cover ‘em With Cash 12/25/2004 12/25/2004 Disabled Teachers Fred Jones 281-555-1111 $150.00	Member Activities for Event
	Date		Hours		Comments
	12/25/2004		5		Organizing
	Member Activities for Event
	Date		Hours		Comments

Assignment Continued:

3. Create the following queries:
1. List all of the members who have been president of the organization
2. List the events for which the club has raised more than $1,000
3. List the number of service hours provided by each member
4. List all the members who worked on the “Help the Homeless” event
5. List the events that have a start date in the first half of 2004

4. Create a form (screen) to capture the data on a new member

5. Create a form (screen) to enter data when a member performs an activity for an event

6. DO NOT EMAIL THIS ASSIGNMENT TO ME. turn in your .accdb file as an “Assignment” in Blackboard. If you do not know how to use Blackboard, click here.