need help on creating a training database

[marbie]

hi there,

i'm really new to access and not very familiar with it. however, i need to create a training database. i'm not sure if this will work better in access or excel... anyhow here's the scenario..

i need to create a training database that contains the training needs of an employee, track down all the trainings he has attended and based from both table, generate a report to find out if the employee is on track of his individual development plan (idp).

how i want the databse to work is that everytime i key in a training name, i can generate a report that contains those who has already taken it, when they took it and those that still needs to take it.

aside from keying the training name, i would also like that if i key in an employee's name or employee id, all the trainings he has taken and those that he still needs to attend will be generates.

i hope you can help me out on this at the soonest.

thank you.

 

[NigelShaw]

hi there,

i'm really new to access and not very familiar with it. however, i need to create a training database. i'm not sure if this will work better in access or excel... anyhow here's the scenario..

i need to create a training database that contains the training needs of an employee, track down all the trainings he has attended and based from both table, generate a report to find out if the employee is on track of his individual development plan (idp).

how i want the databse to work is that everytime i key in a training name, i can generate a report that contains those who has already taken it, when they took it and those that still needs to take it.

aside from keying the training name, i would also like that if i key in an employee's name or employee id, all the trainings he has taken and those that he still needs to attend will be generates.

i hope you can help me out on this at the soonest.

thank you.

Hi,

what 'help' are you looking for? it looks to me that you have made statements of what you want but you havent outlined what the issues or problems are.

Nidge

 

[marbie]

Hi,

Thanks for the reply. I've already made three tables:

1. Employee Data
2. Trainings employees need to take
3. Trainings already taken by employee

Now I'm stuck. I don't know how to link each other so that i can generate the different forms that I want. How do I this?

Thanks!

 

[GinaWhipp]

Does this help?

tblEmployees (PK - eEmployeeID)
tblTraining (PK - tTrainingID)
tblEmployeeTraining
etEmployeeID (FK link to eEmployeeID)
etTrainingID (FK link to tTrainingID)

 

[marbie]

hi...

thanks for all the replies. I'm somewhat moving forward with my database however there are still those i need help with..

1. how do i link an unbound main form with the subform? the link child fields and master fields is there but when i make a selection on the main form, nothing happens in the subform. i'm not sure how to go on with this.

2. in my main form, i created an unbound combo box for employee number and linked several other employee data from this combo box. however, everytime i'll close the file this pops out: 'the changes you requested on the table where not successful because they would create duplicate values in the index, primary key or relationship........." what should i do to address this?

thanks in advance!

 

[GinaWhipp]

1. See...

http://www.access-diva.com/f2.html

2. What fields are on the Main form? And are you sure that Combo Box has no Control Source?

 

[marbie]

hi gina,

i've checked the link you've send but on my form, the link was autogenerted by access. but it still does not work. everytime i make a slection on the main form, the subform does not change. on the other issues, the other filelds are:

last name
first name
middle initial
department
position
salary grade

all of which has control source: employee no.

by the way, i think my cbo are bound forms since it picks up data from the table i created... my apologies for the confusion...

 

[GinaWhipp]

Did you use the wizard to also make the combo box on the main form? It might help if you can send an image of what you have. In the menatime, you need an UNBOUND combo box to use on the main form to look up records... You could use a BOUND one but if you make a mistake you will change the records and you don't want that. (It also expalins the error you get when looking up a record). Use the wizard to make the UNBOUND Combo Box...

 

[marbie]

actually, i manually created the combo boxes in the main form. my probelm with using the wizard in creating the form is that i can't seem to link the combo boxes. how i want this databse to work is that the users will only input their employee no and the rest of the data will appear.

but i'll try your suggestion nevertheless..

here's the file i'm currently working on...

 

[GinaWhipp]

This form makes little sense to me... OPn the main form you have bound fields that can be changed after the User looks them up. Why so many BOUND combo boxes on the Main form?

 

[marbie]

i think i should have made a list box instead. but the main idea here is that the users can make a selection based on their employee number.

 

[GinaWhipp]

Then, again, all you need is to create an UNBOUND Combo Box and then reset the width of the first column from 0 to .3

 

[GinaWhipp]

Perhaps you should review...

A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html

 

[lukedill]

this will get you started.

my first post so can't link, but originally posted by howste at elsmar.com.

 

[marbie]

thanks a bunch for this...

this is how i want to design my dbase although a little bit less complicated. however, being a newbie and all, i need the step by step procedure on how to create this kind of database...

can you help me out on this?

thanks again...

 

[G37Sam]

You're in for some reading my friend, there are tons of book/articles out there. You're basically asking:

I want to create a database application from scratch, how do I do that?

Books have been written about this

 

[lukedill]

thanks a bunch for this...

this is how i want to design my dbase although a little bit less complicated. however, being a newbie and all, i need the step by step procedure on how to create this kind of database...

can you help me out on this?

thanks again...

step by step procedure

step 1 - buy reference material - as of today (9/1), you can get a used copy of microsoft office access 2003: concepts and techniques (shelly cashman) for $0.01 on amazon. a used copy of ms access 2003 inside out is $4.39. shipping will cost you more than the books themselves.

step 2 - trial

step 3 - error

step 4 - go back to step 2



when you're stuck and at risk of breaking everything within reach, come back and ask for help.

 

[marbie]

hi there,

its me again and haven't made much progress... =(

i created a form with unbound combo box which is the employee number. when a user makes a selection on the employee number the rest of the basic employee data is filled up.

the next thing i want to do is to have all training records for that employee appear based on the same selction (employee number). this is where i'm stuck.

i've tried making a subform but i can't seem to link the subform with the main form. what are my other options?

can you help me out on this?

thank you.

 

[G37Sam]

the next thing i want to do is to have all training records for that employee appear based on the same selction (employee number). this is where i'm stuck.

i've tried making a subform but i can't seem to link the subform with the main form. what are my other options?

You'll need to set the subforum's recordsource to filter out the training records for that employee. The easy way would be to link it to a Select Query

 

[marbie]

is the recordsource you're referring to and the source object in the subform properties one and the same?

thanks!