Please Help...........Anyone?

[Guest]

I don't really know if this is possible! I was instructed to create a
database and one of the requirements is as follows, bare with me.

Table involved:
tbl Associate - associate ID, FirstName, LastName, StartStep, Program Start
Date

Query involved:
Certificates Earned - Certificate Code

Here is where it gets interesting!

This is for our training program at work. There are a total of 8 steps in the
program. Each step has a certificate. Associates must complete the
certificate plus have 6months of job experience for each step. Before the
associate starts the program they are required to take a placement test which
they can place out of the first five steps.Depending on where they place
(step1-5) is where there program start date begins. This date is every six
months (3/1/07 , 9/1/07, and so on) untill they have completed the program.

What I am needing to do is have the database see what the start step is,
begin the program start date, add additional dates for the remaining steps,
check which certificates each associate has earned and maybe color that date
field of that step or use a checkbox.

I am not sure how this can be done, form,report, I am lost.
I will provide more info if this is not clear enough. Any help would be great.

Thanks

 

[Guest]

First you should analyse the data requirements. E.g. decide what tables you
will need and what fields belong in those tables and then how the separate
tables will be inter-related. You are the best person to do this since you
know what the requirements are, we don't.
In addition you your Associate table:
You will need a table to define the steps
You will also need a cross-reference table to relate the associates to the
steps
You might need a Certificate table

It sounds like you might need some training in Access yourself before you
can attempt this task.

-Dorian

 

[Guest]

The tbl associates tables has everything I need and qry Certificates Earned
matches all training data of one associate into certificates that the
training data equals, which is also the step (Basic Electric is a
certificate, which is also step 1). Everything is there..........just how to
put it together.
There are too many things that need to happen.
How to I start the Program date at the correct step?
How can I add six months for each step? I know how to add months,time,years,
so on, but how do I do that each step. Say they start at step 3, there are 5
more steps, one step every 6 months.
These are the problems I am running into. I have moderate Access training,
and use it more now then I did in college classes. I just can't figure out
how to write the query. Or wether to start in a form or report.
Any help would be great, Thanks!

 

[131313 via AccessMonster.com]

The tbl associates tables has everything I need and qry Certificates Earned
matches all training data of one associate into certificates that the
training data equals, which is also the step (Basic Electric is a
certificate, which is also step 1). Everything is there..........just how to
put it together.
There are too many things that need to happen.
How to I start the Program date at the correct step?
How can I add six months for each step? I know how to add months,time,years,
so on, but how do I do that each step. Say they start at step 3, there are 5
more steps, one step every 6 months.
These are the problems I am running into. I have moderate Access training,
and use it more now then I did in college classes. I just can't figure out
how to write the query. Or wether to start in a form or report.
Any help would be great, Thanks!

The tbl associates tables has everything I need and qry Certificates Earned
matches all training data of one associate into certificates that the
training data equals, which is also the step (Basic Electric is a
certificate, which is also step 1). Everything is there..........just how to
put it together.
There are too many things that need to happen.
How to I start the Program date at the correct step?
How can I add six months for each step? I know how to add months,time,years,
so on, but how do I do that each step. Say they start at step 3, there are 5
more steps, one step every 6 months.
These are the problems I am running into. I have moderate Access training,
and use it more now then I did in college classes. I just can't figure out
how to write the query. Or wether to start in a form or report.
Any help would be great, Thanks!

First you should analyse the data requirements. E.g. decide what tables you
will need and what fields belong in those tables and then how the separate

[quoted text clipped - 40 lines]

 

[BruceM]

In a relational database a table contains information about a single entity
such as person or program. FirstName and LastName are characteristics or
properties of a person, and belong in the table that holds information about
Associates. ProgramStart is not a characteristic or property of an
Associate, and belongs in its own table. You go on to mention that a query
holds certificate information, but you don't explain in which table that
information is stored. The earlier reply that you analyze your data
requirements is on the mark. Does every associate participate in the exact
same program? I realize that some people can start at a higher step than
others, but is it the case that everybody who takes Step 1 takes the same
Step1, and that everybody who takes Step 8 takes the same Step 8? Is there
only one program for every single person in the company? Does each person
take only that one program, no matter how long they work there? Is it also
the case that there will always be the exact same 8 steps, no more and no
less, and that they will never change?
Since you know how to add time, what is the question about adding time for
each step? Where are the steps stored? You have mentioned only one table,
and no relationships.

 

[131313 via AccessMonster.com]

Firstname, lastName, associate ID, start step, program start date,program,
etc., is all in tbl associates
tbl data entry is the table that holds all associate ID,course completions,
dates .
tbl certificates holds all certificate names, certificate codes, and step
qry Certificates Earned takes the above 3 tables and determines if all
training codes for each certificate (or step) is complete, if so it shows the
associate Id, first name, last name, certificates earned. All informaytion I
need is there. All tables are linked by associate ID or Training code

The program is for all maintenance associates that have the title TDP
(program they are in), it's the same amount of steps, certificates, etc.
total of 8 certificates, steps. all of which are the same for everyone.
The problem I am having is how to set the whole thing up.
How to show that if the associate has placed out of the first 1-4 steps then
show "Tested Out", and how to start the step date at the step following the
last step that was tested out, how to multiply the date for each additional
step. How to maybe have the field certain colors for "Tested Out", Current
step the associate is on, and completed steps. This is where I am having
difficulty.
I will be happy to provide you with more info if needed, I am just backed in
a hole on this one!

The tbl associates tables has everything I need and qry Certificates Earned
matches all training data of one associate into certificates that the
training data equals, which is also the step (Basic Electric is a
certificate, which is also step 1). Everything is there..........just how to
put it together.
There are too many things that need to happen.
How to I start the Program date at the correct step?
How can I add six months for each step? I know how to add months,time,years,
so on, but how do I do that each step. Say they start at step 3, there are 5
more steps, one step every 6 months.
These are the problems I am running into. I have moderate Access training,
and use it more now then I did in college classes. I just can't figure out
how to write the query. Or wether to start in a form or report.
Any help would be great, Thanks!

The tbl associates tables has everything I need and qry Certificates Earned
matches all training data of one associate into certificates that the

[quoted text clipped - 16 lines]