Student course Registration setup

[UnknownJoe]

I have a small DB with tables for Student info and Course Info. The main
purpose of the DB is to be able to combine the two and create a Registration
table (and Form) that allow the user to select a current Course, Dates, and
then enroll or register as many students as necessary on the one form that
will create a record for each in the Registration table.

Any ideas would be appreciated.

Thanks.

JS

 

[Gina Whipp]

UnknownJoe,

Have a look at...
http://www.databasedev.co.uk/student_courses_data_model.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

UnknownJoe,

Just realized you said you already had the tables, you are just looking for
Registration ideas. Well, what tables do you already have? It sounds like
you just need a *Join* table with a few additional fields but you might
already have one but without more data can't be sure.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[KARL DEWEY]

Sounds like you want an 'append' or [make table' query with a Cartesian effect.
Put both tables in the design view grid and select the fields you want in
the output.

When you run the query it will generate records of every combination of the
two tables.

 

[UnknownJoe]

I have 2 tables at this time. One is called Students, with a Student ID,
First Name and Last Name. The 2nd is called Courses, with only Course Name.

Within the 3rd table, which is what I'm looking at ideas for, is a Table and
Form to be called Registrations. Basically, I want to do the following on the
form:

(1) Choose a Course (from Course table)
(2) Choose a Start and End Date
(3) Select any number of Students (from the Student table)

I would prefer to have the form open and select a course, then proceed to
select and add students (ex. 1 - 20 students). I guess the problem would be
that each time I add an additional student, it would need to add another
record to the Registration table.

Thanks.

 

[Gina Whipp]

UnknownJoe,

If I am understanding you correctly... This would be my third table:

tblRegistrations
rStudentID
rCourseID
rStartDate (if not in tblCourses)
rDropped
rAudit
rAdditionalNotes
etc... BUT no fields that are included in tblStudents or tblCourses

Then in a subform you can select (register) students, either by Course (make
that the main form OR just make this your main form and proceed to register
Students and run reports to show who has registered for what.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "TrainingRegistration.mdb" which might prove useful to look
at. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=232

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L