Ask a new question

Microsoft Access Training Database (Please Help)

In an effort to streamline how each employee meets his/her required training hours for the year, I am attempting to build a database in Access.

TABLE 1: Employee First Name, Last Name, Hire Date, & Employee Number (dummy number)

TABLE 2: Training Course Number, Course Topic, Presenter, Credit Hours

My goal is to create a form where I enter (from the sign-in sheets) who attended which training.  From there, a report would be generated monthly to show how close each employee has come to reaching his/her required 30 hours for the year.

I've gotten as far as creation of the tables and I am now LOST.  Can anyone shed some insight on what I should do next, and possibly HOW?

Thanks.

Answer
Answer
Well, you certainly need a third table, and you may need some redesign of your existing tables. Why is the Employee Number a "dummy"? What are the Primary Keys of your tables? A table without a primary key is a bit like a car with no steering gear... not much use! A training database models a many to many relationship: each Employee may take zero, one, or many Courses, and each Course will include zero, one, or many Employees. The proper table structure would be:

tblEmployees
  EmployeeNumber (Primary Key, required)
  LastName
  FirstName
 
John W. Vinson/MVP

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated November 12, 2022 Views 557 Applies to: