Can Access solve my problem? Training matrix with front end surface

[QAsh]

Hi All!


Please consider that I am an absolute beginner in access.

Our company is limited to use only a few softwares. We can use microsoft programs but nothing else. I want to create a database that contains workforce trainings and education (training matrix). This is easy either for me but I want an extra feature:

I would like to create a front end surface where all workers can check which lessons (2-3 page word documents per lesson) they had and they can see a list they still have to read and understand. They also get a questionerry about these lessons from time to time so we can check if the education was effective or not. The direct leader would get notification about workers who has backlogs and about workers who are under the accepted limit.

Can access provide all these features? Could you please give me a frame about the operation of this database in a few words (do we need html coding,macros or vb scripts or acces can handle it alone)?

I would really appreciate it!



Thank you in advance!

[ranman256]

Yes it can be done. You will need to learn some relational database basics.
you cant just start this cold without knowing some basics.
Use table wizards and query wizards to help you.

youll need a tPersons table:
PersonID (autoNum)
firstN
lastN
addr
etc

tClasses table (training classes to take)
TrainID (autoNum)
ClassName (CPR, Algebra)
ClassType (Training, Edu)


tTraining (1 person's training/education)
PTID (auto)
PersonID
TrainID
TrainDate
Notes

the tClasses table would have all classes/training a person can take if needed.
the tPerson ,tTraining would be a 1 to many relationship. Historical tracking of a persons work.
build a master parent form of tPersons, and a child subform for tTraining. Pick items from the tClasses table to add to tTraining.

[QAsh]

Thank you! I will come back if I can ask

[QAsh]

Now I have read an 800 pages long book about access. As I see it took almost 2 months (besides 3 little children it is not bad I think)

Now I can come up with more practical questions I hope:


The training matrix should warn the appropriarate supervisor if somebody from his group has missed a training so the leader can implement it. The direct leaders are also employees and they have their own trainings and supervisors. How should I store these data correctly so I can call these records later? The solution has to handle the case if the supervisor has not fulfilled the training of his group his boss should get information about this as well so some kind of hierarchy should be built in.

Thank you in advance!

[aytee111]

The hierarchy will be built into the tPersons table - a way of knowing what level the person is. At the lowest level will be an employee who can only see their own classes. When the database opens run a procedure (either through the use of a macro called AutoExec or in the OnLoad event of the form that opens) that looks up the person's level. Use Environ("username") to get their login id which is also stored on the tPersons table.

You will also need a table of person ID related to a supervisor ID.

Once you have the level of the person who opened the database you will present the correct information to them:
- if the person is an employee, show them only their classes
- is the person is a supervisor/boss, show them two forms - their classes and the classes of all the people who report to them

For instance, a main form with a tab control with two pages: the first showing the person's classes, the second showing overdue classes. If the person is a supervisor the second will have all classes for all their employees.

The main form will be attached to one class where they can enter comments, ratings, etc for that class.

Once you have this information in the database then you can get any reports needed. FIRST get your table structure right, plan and design it before diving in to forms or queries or reports.