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  

Fields



 
 
Thread Tools Display Modes
  #1  
Old April 17th, 2010, 05:18 PM posted to microsoft.public.access.tablesdbdesign
Nantika
external usenet poster
 
Posts: 4
Default Fields

I am working in an education template and want to see if there is a way to
create a field that can be added to periodically to show all the courses a
person takes from my instructors. I created a field named course but it is
only allowing me to put one course in. How can I make the field list all the
courses?

Thanks,

Nantika
--
Enjoy every day!
  #2  
Old April 17th, 2010, 05:50 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Fields

On Sat, 17 Apr 2010 09:18:01 -0700, Nantika
wrote:

I am working in an education template and want to see if there is a way to
create a field that can be added to periodically to show all the courses a
person takes from my instructors. I created a field named course but it is
only allowing me to put one course in. How can I make the field list all the
courses?

Thanks,

Nantika


You're misunderstaning how relational databases work.

A field should be "atomic" - having one and only one value.

A student-enrollment database is a perfect example of a (very common)
many-to-many relationship. Each Student can take zero, one, or many Courses;
each Course is taken by zero, one or many Students. The proper structure for
this has three tables:

Students
StudentID primary key
LastName
FirstName
other biographical data, but nothing about courses

Courses
CourseNo primary key
CourseTitle
other info about the course as a thing in itself

Enrollment
StudentID link to Students, who's enrolled
CourseNo link to Courses, what are they enrolled in
other info about this course as it pertains to this student, e.g. date
enrolled

You would enter multiple *records* into the Enrollment table for each student.

You may want to look at some of the tutorials in these webpages. I believe
that some of the tutorials use class enrollment as an example:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]
 




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:35 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.