Training Database

  • Thread starter Thread starter geekygirl
  • Start date Start date
G

geekygirl

I am new to access and want to build what I think should be relatively
simple. My customer wants a training database that contains Employee ID,
Name, Position, Date Hired, and Courses taken. He wants to be able to do
two things.

1. Enter new Employees into the database
2. Enter a course and a date and select all the employees that were in that
course, and have all their records updated at the same time.

So, the second portion, I envision a button that is Enter Course, and it
brings up a form that has course name, date, and then a list of available
employees with check box to select each employee that has taken that course.

Is this terribly difficult?

Thanks
Tracy
 
I am new to access and want to build what I think should be relatively
simple. My customer wants a training database that contains Employee ID,
Name, Position, Date Hired, and Courses taken. He wants to be able to do
two things.

1. Enter new Employees into the database
2. Enter a course and a date and select all the employees that were in that
course, and have all their records updated at the same time.

So, the second portion, I envision a button that is Enter Course, and it
brings up a form that has course name, date, and then a list of available
employees with check box to select each employee that has taken that course.

Is this terribly difficult?

Thanks
Tracy
Click to expand...

Ok, I presume this is a class assignment,i.e., homework. What tables and what
relationships do you suppose you will need to model this problem? The question
is, how do you model the problem, as opposed to how do you implement the model
using form, subforms, controls, etc.
 
I am new to access and want to build what I think should be relatively
simple. My customer wants a training database that contains Employee ID,
Name, Position, Date Hired, and Courses taken. He wants to be able to do
two things.

1. Enter new Employees into the database
2. Enter a course and a date and select all the employees that were in that
course, and have all their records updated at the same time.

So, the second portion, I envision a button that is Enter Course, and it
brings up a form that has course name, date, and then a list of available
employees with check box to select each employee that has taken that course.

Is this terribly difficult?

Thanks
Tracy
Click to expand...

This is a perfectly classical beginning relational database exercise. You need
three tables:

Employees
EmployeeID <primary key>
LastName
FirstName
<other biographical data>
NOTHING about Courses in this table!!!

Courses
CourseID <primary key>
CourseName
<other info about the course, e.g. InstructorID link to a table of
instructors, date offered, etc. etc.>
NOTHING about Employees in this table!!!

Enrollment
CourseID <what course is this person enrolled in>
EmployeeID <who's enrolled in this course>
<any other info about this person with regard to this course, e.g.
satisfactory/unsatisfactory completion>

You would use Forms, Subforms and Queries to do what you're describing...
 
I want a similar database, BUT I wamt to add variables. I want to track
'what training does the employee need to complete' based on the job title.
Would that be best accomplished with another table? Also, I'd like the form
to show only the courses required for each employee (based on their title).
Your assistance is appreciated.
 
Glenda

Somewhere you need a list (read "table") of the
trainings-required-by-jobtitle.

One approach to doing what you've described would be to have a main form on
which you look up an employee (and thereby get his/her job title), then use
a listbox that shows all available (but not yet taken) training topics, and
a second listbox that shows all "already-taken" training topics. Take a
look at how MS Access handles the query wizard to get an idea how these
paired listboxes look and act.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top