Prizes won and when - Access 2003

[Joy]

Hi, sorry for the long post .



I’m trying to create a database for employees, track prizes they win and
when.



They have one month (date start) to win the first prize and submit written
proof that they did what they had to do. After the required time (date
end), win or loose, they can move on to the next step but they can never try
for the first prize again.



There are four other prizes they can earn depending on activity. If they
make two sales in the qtr, they get a bonus, if 4 sales, better bonus, etc.
They do different things to earn different prizes and the history is
slightly different for each.



Except for the first prize, they can earn the prizes annually but there is a
limit for each year and I have to keep the history of what they won, the
date they won and the value. Also, I need a way to check who is
approaching the end of their time to earn the first prize.



I've been going around with for several weeks and can’t get it and would so
appreciate help.



Thanks in advance.



Trekkie

 

[Gina Whipp]

Joy,

Then the best place to start is at the beginning...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Fred]

A few notes in addition to the excellent advice already given:

You'll need to rigorously and methodiccally think through exactly what you
want your database application to DO. Some examples:

1. Record instances of prizes given?
2. Record / list the entire participation pool of people?
3. List the prices?
4. Record winners of prizes?
5. Automatically apply constraints, and if so, what to you men by "apply"?
Prevent entry of a price event, show lists of people who meet the constraints
etc. If so, #6 will be required.
6. Record events relevant to the constraints?
7. Automatically issue prizes? If so, #9 will be required.
8. If #7 answer is "yes", what do mean by the DB "issuing" a prize? - list
people that get prizes, do and record a one-time issuance event (print
certificate) etc.
8. Record all events relevant to the winning of prizes? (e.g. sales)
9. Etc.

My gut feel is is that you'll want the DB to automate only 90% of the task,
and also for it to make the human's job easier for the other 10%.

Hope that helps a little.

 

[Joy]

Gina, DS and Fred,
Thank you all for the excellent advice.

I'm not new to this but have never attempted anything this complicated.
Hope it's not beyond me. When I step back, I can begin to see what DS is
saying.

Fred, you mentioned a couple of points I hadn't thought of yet.

Back to the drawing board, as they say.

Thanks again.