Re: Where to start

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You need another table to provide the link between training code and
certificate. This could be as simple as a two-column table. Of course you
have to provide the table and its data before you can write the report.

-Dorian

"131313 via AccessMonster.com" wrote:

Jeff,

Yes one table is just associate information (tbl associate) another table has
all certificates (certificate code, certifiicate name) another table is data
entry (associate number,date of training,training code).

The data entry table is the weekly dump of training data of associate that
completed training each week.

I want a report that when I run it, it will creat a list of associates that
have earned a certificate.

The problem I am having is how to link multiple training codes to one
certificate code. Each group of training codes are unique to a specific
certificate, none are repeated.

I would like the report to list all certificates at the top, all associates
in a column and have check boxes for each certificate earned.

Sorry if this is confusing!



Jeff Boyce wrote:
See comments in-line below:

I have a table with the associates information, a table with training
courses,
[quoted text clipped - 3 lines]
associates number, name, and training course code taken (could be multiple
courses depending on what the associate took in that given week.

If you have an Associates table, presumably with your associates' names, why
are you repeating their names in the Training table?

Are you saying the Training table contains one row for every Course taken by
an Associate?

?what "given week"?<g>

Then I have
a table listing all of the certificate names (Advanced Electrical
Training).
There are numerous other tables that deal with the associates information
(dept.,etc.)

You have Certificates. But where do you connect Courses to Certificates?

Are you saying that you can "complete" Certification in an area by taking,
say 5 specific Courses? Do any of your Courses apply toward more than one
Certification? What is the relationship between Certifications and Courses
(1-many, many-1, many-many)?

The main problem is that I want the database to look for the completed
courses an associate has taken. If the associate has all requirements for
the
certificate, it will show on the report.

I take it you want it to show on the report, but you don't yet have a report
doing this...

Report example: Associate number, Associate Name, Certificate Names (maybe
shown with a checkbox if required courses are complete)

This sounds like you want a report that shows each Associate and ALL
Certifications. The previous description seemed to imply that you only
wanted a single Associate and a single Certification.

The problem I am having is figuring out how to show that these certain 10
courses equal a certain certificate.

This will be determined by what you tell us the relationship is between
Certificates and Courses.

Would this be like a one-to-many? For some reason I don't think it's going
to
be that easy? I have a fair amount of Access knowledge, but this has got
me
confused. If you need more info, let me know.

Regards

Jeff Boyce
Microsoft Office/Access MVP

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200703/1


.

Relevant Pages

  • Re: Re: all reasonable grips wake Garrick, and they economically split Norman too
    ... in addition to the big courses. ... Otherwise the certificate in ... Hector's artist might undermine some honest notes. ...
    (sci.crypt)
  • Re: Where to start
    ... Since a report in Access is based on the underlying data, ... by associates that have completed training. ... link training needed to each certificate. ... I link 5 different courses to point to a certain certificate? ...
    (microsoft.public.access.tablesdbdesign)
  • Certificate and Diploma programmes for SPM holders (poor results)
    ... We have variety of courses for those whom didn't do well in their SPM. ... certificates in Office Administration skill and a vocational Diploma ... Certificate in Health Care Management ...
    (soc.culture.malaysia)
  • Certificate and Diploma programmes for SPM holders (poor results)
    ... We have variety of courses for those whom didn't do well in their SPM. ... certificates in Office Administration skill and a vocational Diploma ... Certificate in Health Care Management ...
    (soc.culture.tamil)
  • Re: Where to start
    ... question -- how are Certificates and Courses related? ... all certificates ... I want a report that when I run it, it will creat a list of associates ... Jeff Boyce wrote: ...
    (microsoft.public.access.tablesdbdesign)