Training Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geekygirl - 22 May 2008 19:30 GMT

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

Reply to this Message

Michael Gramelspacher - 22 May 2008 21:20 GMT

>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,
[quoted text clipped - 13 lines]
>Thanks
>Tracy

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.

Reply to this Message

John W. Vinson - 23 May 2008 02:04 GMT

>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,
[quoted text clipped - 13 lines]
>Thanks
>Tracy

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...

Signature

John W. Vinson [MVP]

Reply to this Message