A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Training Database



 
 
Thread Tools Display Modes
  #1  
Old May 22nd, 2008, 07:30 PM posted to microsoft.public.access.tablesdbdesign
geekygirl
external usenet poster
 
Posts: 1
Default Training Database

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
  #2  
Old May 22nd, 2008, 09:20 PM posted to microsoft.public.access.tablesdbdesign
Michael Gramelspacher
external usenet poster
 
Posts: 482
Default Training Database

On Thu, 22 May 2008 11:30:01 -0700, geekygirl
wrote:

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


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.
  #3  
Old May 23rd, 2008, 02:04 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Training Database

On Thu, 22 May 2008 11:30:01 -0700, geekygirl
wrote:

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


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

John W. Vinson [MVP]
  #4  
Old September 28th, 2009, 05:06 PM posted to microsoft.public.access.tablesdbdesign
Glenda
external usenet poster
 
Posts: 79
Default Training Database

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


"John W. Vinson" wrote:

On Thu, 22 May 2008 11:30:01 -0700, geekygirl
wrote:

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


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

John W. Vinson [MVP]

  #5  
Old September 28th, 2009, 06:28 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Training Database

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

"Glenda" wrote in message
...
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


"John W. Vinson" wrote:

On Thu, 22 May 2008 11:30:01 -0700, geekygirl
wrote:

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


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

John W. Vinson [MVP]



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:15 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.