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  

Student course Registration setup



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2009, 06:04 PM posted to microsoft.public.access.tablesdbdesign
UnknownJoe
external usenet poster
 
Posts: 12
Default Student course Registration setup

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
  #2  
Old September 23rd, 2009, 06:27 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Student course Registration setup

UnknownJoe,

Have a look at...
http://www.databasedev.co.uk/student...ata_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

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



  #3  
Old September 23rd, 2009, 06:30 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Student course Registration setup

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

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



  #4  
Old September 23rd, 2009, 06:46 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Student course Registration setup

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.

--
Build a little, test a little.


"UnknownJoe" wrote:

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

  #5  
Old September 23rd, 2009, 06:53 PM posted to microsoft.public.access.tablesdbdesign
UnknownJoe
external usenet poster
 
Posts: 12
Default Student course Registration setup

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" wrote:

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

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




  #6  
Old September 23rd, 2009, 07:00 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Student course Registration setup

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

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

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

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






  #7  
Old September 23rd, 2009, 07:25 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Student course Registration setup

Typically there would be a Student table to list Student information, a
Course table for information about courses, and a junction table. The
junction table is because one student can take many (i.e. more than one)
course, and one course can be attended by many students.

tblStudent
StudentID (primary key, or PK)
FirstName
LastName
etc.

tblCourse
CourseID (PK)
CourseDescription
etc.

tblEnrollment
StudentCourseID (PK)
StudentID (link to tblStudent)
CourseID (link to tblCourse)
StartDate (or semester)
Other fields relevant to a specific student taking a specific course

There would be a main form based on tblStudent, with a subform based on
tblEnrollment. The Link Child and Link Master properites of the subform
control are set to StudentID. A combo box that gets its row source from
tblCourse is bound to CourseID on the subform.

You would have a separate Course form for populating and updating the Course
table. Or you could do it the other way around, with the Course form as the
main form with an Enrollment subform on which Students are selected, but that
seems an unlikely way to approach it in this case.

An advantage of this system is that you can easily devise queries, forms, and
reports to show either the courses a student is taking, or the students
taking a course.

This is a very quick description of the structure, but maybe it will get you
started.

UnknownJoe wrote:
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


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200909/1

  #8  
Old September 24th, 2009, 08:30 PM posted to microsoft.public.access.tablesdbdesign
Roger Carlson
external usenet poster
 
Posts: 824
Default Student course Registration setup

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 he
http://www.rogersaccesslibrary.com/f...ts.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/...UBED1=ACCESS-L


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



 




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 03:06 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.