Assistance with MS access offline

[jex57]

Hi,
I am not sure if I am allowed to ask here -but if not - I do apologise, I did read the forum rules, but could not find anything pertaining to my request.

I am looking for a person that I would be able to communicate with outside of the forum (the reason being is that I really do not know what I am doing), and need to design a grade book for school rather urgently.
I have done the design in excel - and know what I want the ultimate results to look like - which I can do - but at this stage I am struggling with just my basic table normalisations and creation of capture forms.

If anyone would be willing to assist, it would be greatly appreciate - and I hope I have not breached any forum rules.

 

[ranman256]

each Class has a list of students.
the class then has assignments (tWork) ,tests, etc.
the student is graded on the assign and graded (tStudentWork)



tStudents
--------------
StudentID (autonumber)
FirstN
LastN
Addr
City
St
Zip
phoneH


tClasses (classes offered, Sci101, Tri202)
----------
classID (auto)
courseID
semester
Subject
Room#
ClassTime



tClassRoster (students in 1 classroom)
--------------
RosterID (auto)
ClassID (long)
StudentID (long)
FinalGrade



tWork (all tests,quizes given to class)
----------
WorkID (auto)
RosterID
WorkType (test,lab,quiz)
GradePts



tStudentWork (grade student got on test)
-------------
StudentWorkID
StudentID (long)
WorkID
Grade



tAttend (attendance per class)
---------
AttendID
StudentID
ClassDate
Present (T/F)

 

[strive4peace]

I see ranman has already given you information. I wrote something too.

You should have tables that look something like this:

Students
- StudentID, AutoNumber, PK (Primary Key)
- studLastname, ext
- studFirstname, text
- studSchoolID, text (just guessing on type) -- this should also be Unique

Courses
- CourseID, AutoNumber, PK (Primary Key)
- Coursename, text
- etc

Classes
- ClassID, AutoNumber, PK (Primary Key)
- CourseID, Long Integer (FK -- Foreign Key to Courses)

ClassStudents
- ClassStudID, AutoNumber, PK (Primary Key)
- ClassID, Long Integer, FK (Foreign Key to Classes)
- StudentID, Long Integer, FK (Foreign Key to Students)

Assignments
- AssmntID, AutoNumber, PK (Primary Key)
- ClassStudID, Long Integer, FK (Foreign Key to Students)
- Grade, Integer
- etc

I have outlined these structures assuming you teach many classes -- also, this is just a start to get you thinking on the right track. One of the biggest issues that people face going from Excel to Access is changing their perspective on the way they look at their data.

Learn Access By Crystal playlist
http://www.youtube.com/playlist?p=PL1B2705CCB40CA4CA

 

[Worf]

.

I am looking for a person that I would be able to communicate with outside of the forum

Rule #7:
All new questions should be posted to new threads on the Public Forums. Members should not use the Private Message system, or other members' threads, to request specific assistance with questions posted in the forum. All members are volunteers, contributing their time and expertise where and when they can, and such requests may be deemed harassment.

Do not invite another member to take the question off the forum (i.e. do not suggest that they post to a different forum and do not suggest that they email or private message you the problem).

Likewise, please do not answer questions by creating solutions elsewhere and then referencing those solutions via file links. We ask that you answer the question within the thread itself (note: providing links to existing articles on the internet is acceptable).

To that effect, please do not simply create a file with a solution, and provide a link to that. Some of the issues with providing links to files uploaded to the internet are: those links often expire, many users cannot download files from file-sharing sites due to network security restrictions, and many users are reluctant to download files for personal security reasons.

 

[jex57]

Thank you so much - will see if I can get my structures to work

 

[jex57]

Thank you for the clarity

 

[strive4peace]

you're welcome, happy to help ~