•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 423,532 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,376 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 707 | Replies: 5
 |
•
•
Join Date: Feb 2008
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I'm looking into creating a Access database for marking my students and so they can get there marks online.
The online part is much later mind you but that is my goal.
I need help in the structure of my tables, quaries and reports. I've been using access for a little while but nothing to this scale and i know i'm certainly missing something important to get it to work the way i want.
Tables needed.
Students
-StudID
-FirstName
-LastName
-Course
-Enrollment
Tests
-TestID
-Module
-Units
-Section1
-Section2
-Section3
-Bonus
-Total_Q
Assignments
-AssignID
-Module
-Units
-Description
-Completion
These are the tables i have so far and i know there needs to be some normalization done here to accomplish what i want.
What i want!!!
I would like to be able to have a Form that will allow me to enter all the student info ie(student details, test marks, assignment marks) which i have completed and seems to work fine.
With Reports i would like to be able to show marks for each test in the module and marks for the assignments completed and then an average for the module and then an average for the student all together for the course.
Not having an issue for the module marks but i can not get a sub report to work properly to show me the assignments for that module for that student.
Wow even just typing this i'm lost. Please help !!!
The online part is much later mind you but that is my goal.
I need help in the structure of my tables, quaries and reports. I've been using access for a little while but nothing to this scale and i know i'm certainly missing something important to get it to work the way i want.
Tables needed.
Students
-StudID
-FirstName
-LastName
-Course
-Enrollment
Tests
-TestID
-Module
-Units
-Section1
-Section2
-Section3
-Bonus
-Total_Q
Assignments
-AssignID
-Module
-Units
-Description
-Completion
These are the tables i have so far and i know there needs to be some normalization done here to accomplish what i want.
What i want!!!
I would like to be able to have a Form that will allow me to enter all the student info ie(student details, test marks, assignment marks) which i have completed and seems to work fine.
With Reports i would like to be able to show marks for each test in the module and marks for the assignments completed and then an average for the module and then an average for the student all together for the course.
Not having an issue for the module marks but i can not get a sub report to work properly to show me the assignments for that module for that student.
Wow even just typing this i'm lost. Please help !!!
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,433
Reputation:
Rep Power: 11
Solved Threads: 295
You should also include StudentID in Tests and Assignments tables to associate results with the person as StudentID is unique.
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Feb 2008
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Ok i will include the student is in those tables and see if this helps me when i'm trying to create the reports
•
•
Join Date: Jan 2007
Posts: 2,556
Reputation:
Rep Power: 7
Solved Threads: 114
Make student-id the sorting key of the students table.
Form one-to-many relationships from student to tests, and from student to assignments, using student-id as the key.
Form one-to-many relationships from student to tests, and from student to assignments, using student-id as the key.
Daylight-saving time uses more gasoline
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,433
Reputation:
Rep Power: 11
Solved Threads: 295
•
•
•
•
Originally Posted by MidiMagic 
Make student-id the sorting key of the students table.
Form one-to-many relationships from student to tests, and from student to assignments, using student-id as the key.
Isn't that what I said few days ago ???
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- payment structure for development project (Software Developers' Lounge)
- disposing of a large data structure.... (C++)
- Questions For WebDevelopment =) (HTML and CSS)
- Assignment (C++)
- dynamically update pages (HTML and CSS)
- simple problem with square root (C)
- Why Data Structures???...QUESTIONS INSIDE (C++)
- Structure Help Please (C++)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: ms access online
- Next Thread: Disjoint feature in MS access
