Creating forms for multiple entries

[Pirduan]

Hi,

I am ceating a training activities data entry. In my situation, I have more
than one employees/particpants going for the similar course on the same date.
How can I create a form where I don't have to repeat keying in the
data/information that are the same across those participants(eg; course
title, course date & location,etc). The only information that changes are the
participant names.

I am beginner in Microsoft Access, thus, I am not familiar with programming.

I hope someone could help me in this. Thank you in advance.

 

[John W. Vinson]

Hi,

I am ceating a training activities data entry. In my situation, I have more
than one employees/particpants going for the similar course on the same date.
How can I create a form where I don't have to repeat keying in the
data/information that are the same across those participants(eg; course
title, course date & location,etc). The only information that changes are the
participant names.

I am beginner in Microsoft Access, thus, I am not familiar with programming.

I hope someone could help me in this. Thank you in advance.

No programming is required - only appropriate table and form design.

You have a "Many to Many" relationship - each course has multiple
participants, and each participant can take many courses. You'll need (at
least) three tables:

Courses
CourseID <primary key>
CourseName
<information about the course itself>

Participants
PersonID <primary key>
LastName
FirstName
<other biographical info>

Attendance
CourseID <what was attended>
PersonID <who attended>
<any info about THIS person's attendance at THIS course>

For data entry you could use a Form based on either Courses (if you want to
pick a course and assign people to it) or on Participants (vice versa), with a
Subform based on Attendance.