Help Needed

[sdecaire]

Hi,



I am looking to create an employee training record database in Access. I do not need anything crazy advanced but I would like the following:

The name of the employee
The courses they have taken and the ones they require
An alert to pop up 2 months in advanced to advise of recertifications
The ability to send email notifications to employees advising of recerts

I have absolutely no knowledge of Access and I am not really wanting to spend hundreds of dollars of a professional database.

Someone please help me.

Thank you

[pdebaets]

Do all employees require the same courses, or are there different education "degrees"?

You could probably start with

Table: Employees
PrimaryKey: EmployeeID
Fields: FirstName, LastName, EMailAddress, etc...

Table: Courses
Primary Key: CourseID
Fields: CourseName

Table: EmployeeCourses
PrimaryKey: EmployeeCourseID
Foreign Key Fields: EmployeeID, CourseID
Fields: DateTaken, DateCompleted, ReCertEMailNotificationSent.

[orange]

If you are not familiar with database concepts, then here is an overview

http://forums.aspfree.com/attachment...achmentid=4712