Regarding your user interface (UI)

After you get all the tables right, you will need a form to update/maintain
each of the tables.

You are going to want to have a form to lookup a student (based on the
studentdemographics table) with a lookup box to "find student"
the Main part of this form will have the student demographics stuff in it.
Then you will want to have a set of tabbedpages to display subforms based
on the related tables for that student.
examples:
Telephone numbers
Email Addresses
Plan of Study
etc.

Then you are going to want to look at the entries from the course/semester
perspective

For a selected course who is planning to enroll in that course in which
semester.
For a selected course who is actually enrolled in that course for the
semester.

And from the Concentration perspective:
who is currently enrolled in each concentration
when will they complete the course work?

etc. etc.


Ed Warren

----------------------------table comments-------------------

What's missing is a way to hold the relationships of a student to course
enrollment (planned: course/semester) and/or course enrollment (actual
course/semester) and course completion date/grade.

Also if each student can have one and only one 'program' then the program
data 'could' go into the student table. However, my experience is that each
student will start several programs of study, before completing any one of
them. In which case your application needs to have the ability to record
the courses completed and identify those outstanding in the new study
program.



Here are some of the issues with your tables:

Tables Fields Comments
ConcentrationLookup
ConcentrationID (key) - autonumber
ConcentrationTitle - text
CourseLookup
CourseID (key) - autonumber
CourseNumber - text
CourseToConcentration
ConcentrationID - autonumber
CourseID - text CourseID (match from courseLookup)
EmailLookup
EmailTypeID (key) - autonumber
EmailType - text
HomeSchoolLookup
HomeSchoolID (key)- autonumber
HomeSchool - text
PhoneNumbers
PhoneID (key) - autonumber
StudentID - text StudentID (key) - text
PhoneTypeID - text
PhoneNumber - text
PhoneTypeLookup
PhoneTypeID (key) - autonumber
PhoneType - text
ProgramData
ProgramID (key) - text
StudentID - text
DateAdmitted - date/time
DateUpdated - date/time
ConcentrationID - text ConcentrationID -- should match the
ConcentrationID from Concentration Lookup --Number
StatusID - text FK from StatusLookup.
Comment - memo
Probably want to add a DateCompleted and/or DateWithdrawn
and or Yes/no field to document that the program of study was
completed or student withdrew (this may already be there in the statusID
field)






SemesterLookup
SemesterID (key) - autonumber
SemesterStartDate - date/time
Semester - text
StatusLookup
StatusID (key) - text May want the key to be autoincrement number
StatusType - text
StudentDemographics
StudentID (key) - text Are your student ID's really text or numbers??
FirstName - text
MiddleInitial - text
LastName - text
ProgramID - text not a student characteristic data in
ProgramData Table
ConcentrationTitle - text not a student characteristic in ProgramData
Table
HomeSchool - text
Address1 - text
Address2 - text
City - text
State - text
ZipCode - text
PhoneType - number not a student characteristic
information in Phone Numbers table
PhoneNumber - text not a student characteristic information in Phone
Numbers table
EmailType - number not a student characteristic
information in StudentEmail table.
EmailAddress - memo not a student characteristic information in
StudentEmail table.
Advisor - text not a student characterisitc should be in the
ProgramData table
DateUpdated - date/time
StudentEmail
EmailID (key) - text Probably should be number and autoinc
StudentID - text
EmailTypeID - text Should match EmailTypeID in Email (number)
EmailAddress - memo
CourseStatusLookup
CourseStatusID - autonumber
CourseStatus - text
Add CourseStatusDate -- date/time

"BMB" wrote in message
...
Thank you for the suggestions. They have helped. I think that I have all
the tables constructed (maybe), but the assimilation part is proving more
complicated than I had thought. As I establish relationships between the
tables, I seem to get less functionality and information retention than
before. The following is my table structure. Further assistance would be
greatly appreciated.

Table structure-----

ConcentrationLookup
ConcentrationID (key) - autonumber
ConcentrationTitle - text
CourseLookup
CourseID (key) - autonumber
CourseNumber - text
CourseToConcentration
ConcentrationID - autonumber
CourseID - text
EmailLookup
EmailTypeID (key) - autonumber
EmailType - text
HomeSchoolLookup
HomeSchoolID (key) - autonumber
HomeSchool - text
PhoneNumbers
PhoneID (key) - autonumber
StudentID - text
PhoneTypeID - text
PhoneNumber - text
PhoneTypeLookup
PhoneTypeID (key) - autonumber
PhoneType - text
ProgramData
ProgramID (key) - text
StudentID - text
DateAdmitted - date/time
DateUpdated - date/time
ConcentrationID - text
StatusID - text
Comment - memo
SemesterLookup
SemesterID (key) - autonumber
SemesterStartDate - date/time
Semester - text
StatusLookup
StatusID (key) - text
StatusType - text
StudentDemographics
StudentID (key) - text
FirstName - text
MiddleInitial - text
LastName - text
ProgramID - text
ConcentrationTitle - text
HomeSchool - text
Address1 - text
Address2 - text
City - text
State - text
ZipCode - text
PhoneType - number
PhoneNumber - text
EmailType - number
EmailAddress - memo
Advisor - text
DateUpdated - date/time
StudentEmail
EmailID (key) - text
StudentID - text
EmailTypeID - text
EmailAddress - memo
CourseStatusLookup
CourseStatusID - autonumber
CourseStatus - text

The following information may be necessary: ProgramID is a four-digit
number
that we assign to students as they apply for our program as a method of
internal tracking; all courses are available each semester; there are 7
course requirements that are common to all 5 concentrations.

I would like to create a tabbed form that contains one tab for basic
student
information and subsequent tabs that contain scheduling data for the
requisite courses based upon the student's chosen concentration (i.e., one
tab for each concentration, but only the appropriate tab accessible based
on
the "Concentration" selection on tab 1).

If you're still even reading this, thanks.