Recent content by RandRob

I did look at this page as suggested and understand what is being done here The issue with me using this would be there is a form that shows all the data in a single view so it can be updated easily here is a link so you can see a capture of the form...

Im not sure how you are saying to set up the tables initially i was going to have a tabel for each course each one with the grade date recieved and date sent i needed to tie these all in to a form so data could be updated this is when i was told to use one table i now know how to link all...

Here is what i am hoping to do in an excisting database there is a table that is set up like this id 01_grade 01_recieved 02_grade 02_recived 03_grade 03_Recieved 01 95 2/22/2009 80 2/22/2009 100 2/01/2009 02 85 2/10/2009 100 2/22/2009 100 1/01/2009 with this go on for 50 grades what i...

how should it be designed? here is a brief look at what i have currently we will use this to track more then 9000 students taking bible coarses in prisons we currently have 60 separate courses i have three tables one for basic enrolment info one for updated info (home address etc if...

I have a excell spreadsheet which will contain Scanned test scores in this spread sheet i will have a column for a student id a column for a coarse name and a column for the score ID Course_Name Course Grade 101 Course 1 98 101 Course 2 89 102 Course 1 85 i also will have a access table...