Re: Where to start

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

See comments in-line below:

"131313 via AccessMonster.com" <u32128@uwe> wrote in message
news:6e82cc0c6652a@xxxxxx
I have a table with the associates information, a table with training
courses,
around 45 different ones. Each of these have it's own code like LAB1324
along
with it's description. I also have training data in a table with the
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


.

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
    ... have to provide the table and its data before you can write the report. ... all certificates another table is data ... The problem I am having is how to link multiple training codes to one ... courses depending on what the associate took in that given week. ...
    (microsoft.public.access.tablesdbdesign)