If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Prizes won and when - Access 2003
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 |
#3
|
|||
|
|||
Prizes won and when - Access 2003
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 |
#4
|
|||
|
|||
Prizes won and when - Access 2003
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. |
#5
|
|||
|
|||
Prizes won and when - Access 2003
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. |
Thread Tools | |
Display Modes | |
|
|