Training DataBase

G

Glenda

I have a database with 3 tables. Table 1 has the employee name and job
title, table 2 has the titles of the training required for each job title,
table 3 is the training history (date, training title, level of competency
[there are 3 levels of competency - so possibly 3 training records for each
training title for each employee]). I would like to print a report that has
the employee names along the side of the page with the training titles at the
top. I would like to enter an "R" if the training is required and has not
started, leave it blank if the training is not required, an "A" if the
employee is at level A, "B" if at level B, "C" if at level C.

I am pretty challenged with Access, please help.
 
S

S.Clark

Ensure that your tables use a numeric primary key, and use that value for
linking. Once that's shored up, build forms with subforms to assist with the
data entry and viewing of data. Personally, I think you need a 4th table for
just Job Titles.

From there, build a form to display the Employees (main form), with 2
subforms of 'training available by job title', and 'training attended'.

Explore these concepts and go, go, go.
 
G

Glenda

I appreciate your answer but wow, you really simplified my request. I'd like
to combine the subforms and make one continuous report - so a person isn't
jumping back and forth between the 2 forms, completed vs needed, do you know
a method?
--
Glenda


S.Clark said:
Ensure that your tables use a numeric primary key, and use that value for
linking. Once that's shored up, build forms with subforms to assist with the
data entry and viewing of data. Personally, I think you need a 4th table for
just Job Titles.

From there, build a form to display the Employees (main form), with 2
subforms of 'training available by job title', and 'training attended'.

Explore these concepts and go, go, go.

Glenda said:
I have a database with 3 tables. Table 1 has the employee name and job
title, table 2 has the titles of the training required for each job title,
table 3 is the training history (date, training title, level of competency
[there are 3 levels of competency - so possibly 3 training records for each
training title for each employee]). I would like to print a report that has
the employee names along the side of the page with the training titles at the
top. I would like to enter an "R" if the training is required and has not
started, leave it blank if the training is not required, an "A" if the
employee is at level A, "B" if at level B, "C" if at level C.

I am pretty challenged with Access, please help.
 
S

scott04

You can create a status table and link it to main table. Once that is
completed then you can set your form to only pull up pending or work in
progress requests....or you can have Yes/No checkboxes on your form whether
training is required. Just my ten cents.

Glenda said:
I appreciate your answer but wow, you really simplified my request. I'd like
to combine the subforms and make one continuous report - so a person isn't
jumping back and forth between the 2 forms, completed vs needed, do you know
a method?
--
Glenda


S.Clark said:
Ensure that your tables use a numeric primary key, and use that value for
linking. Once that's shored up, build forms with subforms to assist with the
data entry and viewing of data. Personally, I think you need a 4th table for
just Job Titles.

From there, build a form to display the Employees (main form), with 2
subforms of 'training available by job title', and 'training attended'.

Explore these concepts and go, go, go.

Glenda said:
I have a database with 3 tables. Table 1 has the employee name and job
title, table 2 has the titles of the training required for each job title,
table 3 is the training history (date, training title, level of competency
[there are 3 levels of competency - so possibly 3 training records for each
training title for each employee]). I would like to print a report that has
the employee names along the side of the page with the training titles at the
top. I would like to enter an "R" if the training is required and has not
started, leave it blank if the training is not required, an "A" if the
employee is at level A, "B" if at level B, "C" if at level C.

I am pretty challenged with Access, please help.
 
G

Glenda

I just discovered 'linking tables'. I would link the status table to the
Training Title table, correct?
--
Glenda


scott04 said:
You can create a status table and link it to main table. Once that is
completed then you can set your form to only pull up pending or work in
progress requests....or you can have Yes/No checkboxes on your form whether
training is required. Just my ten cents.

Glenda said:
I appreciate your answer but wow, you really simplified my request. I'd like
to combine the subforms and make one continuous report - so a person isn't
jumping back and forth between the 2 forms, completed vs needed, do you know
a method?
--
Glenda


S.Clark said:
Ensure that your tables use a numeric primary key, and use that value for
linking. Once that's shored up, build forms with subforms to assist with the
data entry and viewing of data. Personally, I think you need a 4th table for
just Job Titles.

From there, build a form to display the Employees (main form), with 2
subforms of 'training available by job title', and 'training attended'.

Explore these concepts and go, go, go.

:

I have a database with 3 tables. Table 1 has the employee name and job
title, table 2 has the titles of the training required for each job title,
table 3 is the training history (date, training title, level of competency
[there are 3 levels of competency - so possibly 3 training records for each
training title for each employee]). I would like to print a report that has
the employee names along the side of the page with the training titles at the
top. I would like to enter an "R" if the training is required and has not
started, leave it blank if the training is not required, an "A" if the
employee is at level A, "B" if at level B, "C" if at level C.

I am pretty challenged with Access, please help.
 
S

Steve

Hi Glenda,

Start by looking at Crosstab Query in the help file. You need to create a
crosstab query based on all three of your tables. Once you have the crosstab
query returning records the way you want then you need to create a crosstab
report whose recordsource is the crosstab query. You can find info on the
crosstab report in the Help file also.

In the alternative, I could create your report for you for a modest fee. I
provide help with Access, Excel and Word applications for a small fee. If
you want my help, contact me.

Steve
(e-mail address removed)


J. Williams said:
See http://www.TrainingDatabase.com. There are some reasonably priced
Access
databases here.

Glenda said:
I have a database with 3 tables. Table 1 has the employee name and job
title, table 2 has the titles of the training required for each job
title,
table 3 is the training history (date, training title, level of
competency
[there are 3 levels of competency - so possibly 3 training records for
each
training title for each employee]). I would like to print a report that
has
the employee names along the side of the page with the training titles at
the
top. I would like to enter an "R" if the training is required and has
not
started, leave it blank if the training is not required, an "A" if the
employee is at level A, "B" if at level B, "C" if at level C.

I am pretty challenged with Access, please help.
 
J

John... Visio MVP

Steve said:
In the alternative, I could create your report for you for a modest fee. I
provide help with Access, Excel and Word applications for a small fee. If
you want my help, contact me.

Steve




Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP
 
G

Glenda

The link only has a database for use with Access 2007. I am using Access
2003.
--
Glenda


J. Williams said:
See http://www.TrainingDatabase.com. There are some reasonably priced Access
databases here.

Glenda said:
I have a database with 3 tables. Table 1 has the employee name and job
title, table 2 has the titles of the training required for each job title,
table 3 is the training history (date, training title, level of competency
[there are 3 levels of competency - so possibly 3 training records for each
training title for each employee]). I would like to print a report that has
the employee names along the side of the page with the training titles at the
top. I would like to enter an "R" if the training is required and has not
started, leave it blank if the training is not required, an "A" if the
employee is at level A, "B" if at level B, "C" if at level C.

I am pretty challenged with Access, please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top