Tim-
This seems pretty straightforward.
Students:
StudentID, StudLastName, StudFirstname, etc…
Courses:
CourseID, CourseDescription, etc…
StudentCourses:
StudentID, CourseID, EnrollmentDate, CompletedDate, Grade
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 18, 2014, at 9:36 PM, timdbui@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Would any of you please help me to set up the table, form and query to deal with my situation?
I have a group of students (about 200) who will be taking several classes in a semester (about 6 courses per student out of total of 50 available courses offered).
How should I create a table to contain these data and how should I create a form so that the student can select 6 of the courses they desire?
Finally, how should I create a query to total the names of the students that registered for each course?
I have tried to look up on youtube to see if there are any available videos to watch but have not been able to find them.
Thanks you so much in advance for your help!
Tim
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar