Prizes won and when - Access 2003

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

Joy,

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

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...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

"Joy" wrote in message
...
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

What you are trying to do can be a rather complicated database setup. You
will want to normalize your tables to max with something like this because of
the variables that can allow or disallow a prize.

Think of each thing as a separate table and how each of them then relates to
one another. Prizes, Employees, Prize Dates, history, proof per prize per
employee (a join table with all the Primary Keys of the other related tables),
etc etc etc.

If you are a noob... good luck with this one right out of the starting gates,
there are some interesting twists to stuff like this and you need to get the
table design down first before trying to put any code behind making them work.



Joy wrote:
Hi, sorry for the long post .

--
DS

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200903/1

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.

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.




"Fred" wrote in message
...
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.