Is Access even the right idea?

I'm sure that with your vast expertise you could actually provide BMB some
help in trying to sort all this out then he/she could learn to solve the
problem.

Then the next time BMB is asked to solve a data problem he/she will have
devloped the knowledge and experience needed, leading eventually to
promotion and tenure and a life of luxury and fullfillment. A life, your
offer, will deny him/her.

I'm not sure you are aware of the terrible financial and psychological
damage your offer to sell could cause BMB.

I'm passionate about data. Microsoft Access is a great tool for the newbie
to 'access' and display data. Therefore, I enjoy trying to share what
little I have learned with others struggling to get a start with relational
databases. I have also benefited greatly from some of the 'stupid
questions' I have posted with this group and gotten valued advice.

In short I think it better to "teach one to fish" rather than to "give one a
fish".

It is obvious that you want to sell fish, not teach fishing!

I recommend you set up your 'fish monger shop' in an appropriate dark
alleyway rather than in the middle of the school grounds.

(:

Ed Warren


"PC Datasheet" wrote in message
nk.net...
If the complication is becoming too frustrating, please consider that I
can build the database for you for a very reasonable fee. If you want
help, contact me at my email address below.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


"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.

Thanks Warren.

It is nice to see that others understand the spirit of free support.

John... Visio MVP

"Ed Warren" wrote in message
...
I'm sure that with your vast expertise you could actually provide BMB some
help in trying to sort all this out then he/she could learn to solve the
problem.

Then the next time BMB is asked to solve a data problem he/she will have
devloped the knowledge and experience needed, leading eventually to
promotion and tenure and a life of luxury and fullfillment. A life, your
offer, will deny him/her.

I'm not sure you are aware of the terrible financial and psychological
damage your offer to sell could cause BMB.

I'm passionate about data. Microsoft Access is a great tool for the
newbie to 'access' and display data. Therefore, I enjoy trying to share
what little I have learned with others struggling to get a start with
relational databases. I have also benefited greatly from some of the
'stupid questions' I have posted with this group and gotten valued advice.

In short I think it better to "teach one to fish" rather than to "give one
a fish".

It is obvious that you want to sell fish, not teach fishing!

I recommend you set up your 'fish monger shop' in an appropriate dark
alleyway rather than in the middle of the school grounds.

(:

Ed Warren

"PC Datasheet" wrote in message
nk.net...
If the complication is becoming too frustrating, please consider that I
can build the database for you for a very reasonable fee. If you want
help, contact me at my email address below.

Ed,

If you go back over time you will see that I provided advice and support at
a ratio of ten to one or more to responses where I asked the poster to
contact me if he needed help. I judiciously chose where to post my offer to
help to posters where it was highly unlikely that they would get the
solution they needed from the newsgroup. Over the years over 1050 Access
users from the newsgroups have contacted me asking for help and willing to
pay a fee for it. Don't get me wrong, I always encourage them to seek help
from the newsgroups telling them it is free. Arno R and his dimwit sidekick
John Marshall want to steal away this option for help from anyone who comes
to the newsgroup looking for help. Go back over time and see how many
responses of help were posted by Arno R and his dimwit friend. The dimwit
friend isn't even an Access MVP!

Steve
PC Datasheet

"Ed Warren" wrote in message
...
I'm sure that with your vast expertise you could actually provide BMB some
help in trying to sort all this out then he/she could learn to solve the
problem.

Then the next time BMB is asked to solve a data problem he/she will have
devloped the knowledge and experience needed, leading eventually to
promotion and tenure and a life of luxury and fullfillment. A life, your
offer, will deny him/her.

I'm not sure you are aware of the terrible financial and psychological
damage your offer to sell could cause BMB.

I'm passionate about data. Microsoft Access is a great tool for the
newbie to 'access' and display data. Therefore, I enjoy trying to share
what little I have learned with others struggling to get a start with
relational databases. I have also benefited greatly from some of the
'stupid questions' I have posted with this group and gotten valued advice.

In short I think it better to "teach one to fish" rather than to "give one
a fish".

It is obvious that you want to sell fish, not teach fishing!

I recommend you set up your 'fish monger shop' in an appropriate dark
alleyway rather than in the middle of the school grounds.

(:

Ed Warren


"PC Datasheet" wrote in message
nk.net...
If the complication is becoming too frustrating, please consider that I
can build the database for you for a very reasonable fee. If you want
help, contact me at my email address below.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling?
Need
room reservations scheduling? Need employee work scheduling? Contact me!


"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.

Oh I'm so hurt. Name calling from a failed plumber, just won't do it. So
I'll just add this to the long list of items you will never apoligize for.

It has nothing to do with 10 to 1, 100 to 1, or a million to 1. You still
post messages soliciting work. The issue is the 1 not the 10, 100 or
million.

These newsgroups were set up my Microsoft to allow free peer to peer help,
solicitions was not one of the intended "options for help".

So by posting a few answers, some of which you have plagerized, absolves you
from following the spirit of the newsgroups?

The number of responses I or Arno make to these newsgroups is immaterial to
the issue. It's like saying that a pedestrian can not comment on a traffic
accident because he was not driving.

So when will your following of 1050, jump to your defence?

John... Visio MVP


"PC Datasheet" wrote in message
nk.net...
Ed,

If you go back over time you will see that I provided advice and support
at a ratio of ten to one or more to responses where I asked the poster to
contact me if he needed help. I judiciously chose where to post my offer
to help to posters where it was highly unlikely that they would get the
solution they needed from the newsgroup. Over the years over 1050 Access
users from the newsgroups have contacted me asking for help and willing to
pay a fee for it. Don't get me wrong, I always encourage them to seek help
from the newsgroups telling them it is free. Arno R and his dimwit
sidekick John Marshall want to steal away this option for help from anyone
who comes to the newsgroup looking for help. Go back over time and see how
many responses of help were posted by Arno R and his dimwit friend. The
dimwit friend isn't even an Access MVP!

Steve PC Datasheet

Your job hunting posts are annoying in and of themselves, no matter what
Arno and/or John Marshall think and/or say!

As I said I'm a data freak, math major, and statistician, I took up your
challenge.
For the most recent posts under your name:
Out of 41 posts:

You were asking for help 12
You were providing Help 4
You were advertising and or defending advertising 25


-- 9.76% help

Maybe in Washington DC this could be spun as a 10:1 Providing help record.

-----by the way I will not respond to any further posts on this subject on
this thread-------I'm going back to and find someone to actually help !!
Ed Warren.

"PC Datasheet" wrote in message
nk.net...
Ed,

If you go back over time you will see that I provided advice and support
at a ratio of ten to one or more to responses where I asked the poster to
contact me if he needed help. I judiciously chose where to post my offer
to help to posters where it was highly unlikely that they would get the
solution they needed from the newsgroup. Over the years over 1050 Access
users from the newsgroups have contacted me asking for help and willing to
pay a fee for it. Don't get me wrong, I always encourage them to seek help
from the newsgroups telling them it is free. Arno R and his dimwit
sidekick John Marshall want to steal away this option for help from anyone
who comes to the newsgroup looking for help. Go back over time and see how
many responses of help were posted by Arno R and his dimwit friend. The
dimwit friend isn't even an Access MVP!

Steve
PC Datasheet

"Ed Warren" wrote in message
...
I'm sure that with your vast expertise you could actually provide BMB
some help in trying to sort all this out then he/she could learn to solve
the problem.

Then the next time BMB is asked to solve a data problem he/she will have
devloped the knowledge and experience needed, leading eventually to
promotion and tenure and a life of luxury and fullfillment. A life, your
offer, will deny him/her.

I'm not sure you are aware of the terrible financial and psychological
damage your offer to sell could cause BMB.

I'm passionate about data. Microsoft Access is a great tool for the
newbie to 'access' and display data. Therefore, I enjoy trying to share
what little I have learned with others struggling to get a start with
relational databases. I have also benefited greatly from some of the
'stupid questions' I have posted with this group and gotten valued
advice.

In short I think it better to "teach one to fish" rather than to "give
one a fish".

It is obvious that you want to sell fish, not teach fishing!

I recommend you set up your 'fish monger shop' in an appropriate dark
alleyway rather than in the middle of the school grounds.

(:

Ed Warren


"PC Datasheet" wrote in message
nk.net...
If the complication is becoming too frustrating, please consider that I
can build the database for you for a very reasonable fee. If you want
help, contact me at my email address below.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for
a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling?
Need
room reservations scheduling? Need employee work scheduling? Contact me!


"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.

No Access is not right for you. From what I read you are going to use a lot
of data. Access can only do 10,000 transactions at a time. So if you have
multiple users updating and deleting and whatever, Access will crash if
10,000 users access.
Oracle can handle the whole world's population if they decide to access it
at the same time. Value -- Access - $100 Oracle - $100,000 for your school
Oracle is totally web, so no need for software on your computer. And that
means
ease. I'm against ACCESS because I've seen it in action with large
organization like yours, and "Pane Freezing" is common. Microsoft is aware of
this, and that's why Mr. Ellison from Oracle is #2 next to Bill Gates

"tina" wrote:

well, i'd say Access is the place to house, organize, update, and analyze
the data - but it doesn't sound like a trivial undertaking. how comfortable
are you with the Access software? and how familiar are you with the concepts
of data modeling/normalization/table relationships? if your answer to the
second question is "not very" or "not at all", then i recommend you start
there. this is definitely not a project that you want to throw together
willy-nilly, especially since you want to use the data to project future
business needs.

to learn relational data modeling methodology and the principles of
normalization, an excellent text is Database Design for Mere Mortals by
Michael Hernandez. there are also a number of links to helpful material at
http://home.bendbroadband.com/conrad...resources.html
beginning with the Database Design 101 and Starting Out links.

hth


"BMB" wrote in message
...
I have recently had a large amount of data dumped on me and was asked to
organize it. If the data were finite, it wouldn't be a problem; but it is
subject to weekly updates with new records being added. This might take
some
explaining. . .

I work in a university program office and am trying to figure out the best
way to keep up with which students are in which degree concentrations,
each
of which has its own set of requisite courses. For example, there are 5
different degree concentrations with the program; one has only 6 required
courses, one has 16. I have projected dates that students anticipate
taking
the courses that are required for them (e.g., "Spring, 2007").

Keeping up with the basic data (name, address, phone, program, etc.) is
fairly simple. I have it set up in Access and Excel. But what I want is
some kind of smart form that will know which classes are required of which
students based on their concentrations and can create detailed reports
showing how many students are projected to take each class during upcoming
semesters.

Does this make sense to anyone? I'm looking at it and still not sure what
to do. Any help with deciding which application (and how) to use would be
most appreciated.

What universe are you living in? The poor soul is currently managing the
data with excel, and does weekly updates. That is a far far cry from
needing 10,000 concurrent transactions.
Matter of fact I would be surprised it their entire database was over a few
100 records in length.

They need a bucket, not a freight train ;

Ed Warren

"Ian" wrote in message
...
No Access is not right for you. From what I read you are going to use a
lot
of data. Access can only do 10,000 transactions at a time. So if you have
multiple users updating and deleting and whatever, Access will crash if
10,000 users access.
Oracle can handle the whole world's population if they decide to access it
at the same time. Value -- Access - $100 Oracle - $100,000 for your
school
Oracle is totally web, so no need for software on your computer. And that
means
ease. I'm against ACCESS because I've seen it in action with large
organization like yours, and "Pane Freezing" is common. Microsoft is aware
of
this, and that's why Mr. Ellison from Oracle is #2 next to Bill Gates

"tina" wrote:

well, i'd say Access is the place to house, organize, update, and analyze
the data - but it doesn't sound like a trivial undertaking. how
comfortable
are you with the Access software? and how familiar are you with the
concepts
of data modeling/normalization/table relationships? if your answer to the
second question is "not very" or "not at all", then i recommend you start
there. this is definitely not a project that you want to throw together
willy-nilly, especially since you want to use the data to project future
business needs.

to learn relational data modeling methodology and the principles of
normalization, an excellent text is Database Design for Mere Mortals by
Michael Hernandez. there are also a number of links to helpful material
at
http://home.bendbroadband.com/conrad...resources.html
beginning with the Database Design 101 and Starting Out links.

hth


"BMB" wrote in message
...
I have recently had a large amount of data dumped on me and was asked
to
organize it. If the data were finite, it wouldn't be a problem; but it
is
subject to weekly updates with new records being added. This might
take
some
explaining. . .

I work in a university program office and am trying to figure out the
best
way to keep up with which students are in which degree concentrations,
each
of which has its own set of requisite courses. For example, there are
5
different degree concentrations with the program; one has only 6
required
courses, one has 16. I have projected dates that students anticipate
taking
the courses that are required for them (e.g., "Spring, 2007").

Keeping up with the basic data (name, address, phone, program, etc.) is
fairly simple. I have it set up in Access and Excel. But what I want
is
some kind of smart form that will know which classes are required of
which
students based on their concentrations and can create detailed reports
showing how many students are projected to take each class during
upcoming
semesters.

Does this make sense to anyone? I'm looking at it and still not sure
what
to do. Any help with deciding which application (and how) to use would
be
most appreciated.

Good Morning, Gentlemen,

OK, so I'm still plugging away at this database, and while I'm a big fan of
the 1st Amendment, could you please find somewhere else to argue? Not that I
don't thoroughly enjoy the disappointment of logging on after receiving an
e-mail that someone has posted a reply and finding out that it's from some
schmuck who has nothing better to do that plug his own business. . . Steve,
if I wanted to (or even could. . .) pay someone for this, wouldn't it make
more sense for me to explore that option up-front instead of wasting my time
trying to learn how to do this for myself? I haven't written to you eagerly
expressing my rapacious desire for your oh-so-unselfish services, so please
find someone else's post to fill with nonsensical garbage. That will be all.

"PC Datasheet" wrote:

Ed,

If you go back over time you will see that I provided advice and support at
a ratio of ten to one or more to responses where I asked the poster to
contact me if he needed help. I judiciously chose where to post my offer to
help to posters where it was highly unlikely that they would get the
solution they needed from the newsgroup. Over the years over 1050 Access
users from the newsgroups have contacted me asking for help and willing to
pay a fee for it. Don't get me wrong, I always encourage them to seek help
from the newsgroups telling them it is free. Arno R and his dimwit sidekick
John Marshall want to steal away this option for help from anyone who comes
to the newsgroup looking for help. Go back over time and see how many
responses of help were posted by Arno R and his dimwit friend. The dimwit
friend isn't even an Access MVP!

Steve
PC Datasheet

"Ed Warren" wrote in message
...
I'm sure that with your vast expertise you could actually provide BMB some
help in trying to sort all this out then he/she could learn to solve the
problem.

Then the next time BMB is asked to solve a data problem he/she will have
devloped the knowledge and experience needed, leading eventually to
promotion and tenure and a life of luxury and fullfillment. A life, your
offer, will deny him/her.

I'm not sure you are aware of the terrible financial and psychological
damage your offer to sell could cause BMB.

I'm passionate about data. Microsoft Access is a great tool for the
newbie to 'access' and display data. Therefore, I enjoy trying to share
what little I have learned with others struggling to get a start with
relational databases. I have also benefited greatly from some of the
'stupid questions' I have posted with this group and gotten valued advice.

In short I think it better to "teach one to fish" rather than to "give one
a fish".

It is obvious that you want to sell fish, not teach fishing!

I recommend you set up your 'fish monger shop' in an appropriate dark
alleyway rather than in the middle of the school grounds.

(:

Ed Warren


"PC Datasheet" wrote in message
nk.net...
If the complication is becoming too frustrating, please consider that I
can build the database for you for a very reasonable fee. If you want
help, contact me at my email address below.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling?
Need
room reservations scheduling? Need employee work scheduling? Contact me!


"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.

First of all, I'd like to thank everyone who has helped with this project so
far. You have all been a great help (except for Steve, anyway). Here's my
next question - which, of course, proves how much of a novice I am with
Access: when creating a form, is there a way that the answer in one field
(chosen from a drop-down list) can lock other tabbed pages and require that
the user input data on others? For example, if I answer the question
concerning student concentration, can the form itself mandate that the
pertinent data required by that concentration be input while simultaneously
disallowing input of other data for different concentrations (perhaps by
locking out the tabbed pages on which that data would be input if relevant)?
After reading up on database issues on sites that have been recommended here,
I've tried playing with the Master and Child fields, but nothing that I've
tried works. If I need to provide more information, just let me know.

Again, thank you all for the help.

Yes
You will need to:
a. Spend some amount of time defining exactly the behaviors you want to
implement in your software.
b. Write Visual Basic Code to implement your vision.
You will start with one of the events in your combobox, most likely
on_exit then in English
"When I exit the combobox, if it is set to concentration
number 1 then I want show tabs 1,5,7 and not allow the user to exit until
all of these are filled in."

Ed Warren.

"BMB" wrote in message
news
First of all, I'd like to thank everyone who has helped with this project
so
far. You have all been a great help (except for Steve, anyway). Here's
my
next question - which, of course, proves how much of a novice I am with
Access: when creating a form, is there a way that the answer in one field
(chosen from a drop-down list) can lock other tabbed pages and require
that
the user input data on others? For example, if I answer the question
concerning student concentration, can the form itself mandate that the
pertinent data required by that concentration be input while
simultaneously
disallowing input of other data for different concentrations (perhaps by
locking out the tabbed pages on which that data would be input if
relevant)?
After reading up on database issues on sites that have been recommended
here,
I've tried playing with the Master and Child fields, but nothing that I've
tried works. If I need to provide more information, just let me know.

Again, thank you all for the help.