Hi,
I am going to sing the song of so many before me: "HELP, I desparately need your expertise!" I am sooo new at this and I have not progressed very far despite my efforts. I have , on and off FOR A COUPLE OF YEARS, been trying to design a database to record Community Service Hours for a private school I work for. They have no money to invest in this endeavor so I have it taken on by myself and spent a LOT of my own money. Up until now, I have been using a spreadsheet. :o It is not going well. I have researched ad nauseum and for the first year I was attempting to design it in Access. yuck! I have really tried but one of the things that keeps stumping me is how to design it to break down on the service form by the students year in school (i.e. freshman, sophomore, etc.). Our service program is different than most. We require that each year a certain amount of hours are completed. (i.e. freshman = 10 hours, sophomore = 20 hours, juniors = 30 hours, seniors = 40 hours). If a student does not complete their hours, then they receive an F for the Comm. Svc grade for that year. So I must be able to see each year broken out. When entering the service hours each time, which might be 1 form for the year or 30 forms for the year per student, I do not always have their current grade. So I want to have a Service Hour input form that doesn't require I put in their current grade. I will each August update the student table with the student's information (i.e. current grade) so their record will reflect their current grade. I can obtain this information from the school database and save it to a spreadsheet and then save it to the Alpha database.
The tables that I have right now are: Students, Organizations, School year (I will input the year that the service should be credited to, 07-08),[B]Grade requirements [B](9th = 10 hours, 10th = 20 hours),Service Category(disadvantaged, disabled, elderly, environment).
I wanted to have an input form for each service verification and then have a student service record form so that I can review each student's service history broken down by year in school (9th 10th, etc.).
I have held off as long as I could before posting this message but I am starting to feel defeated. No one believes that this database will come to be. I know for you this is elementary but I am having a definite mind block that I can't seem to get over. PLEASE HELP!
I am going to sing the song of so many before me: "HELP, I desparately need your expertise!" I am sooo new at this and I have not progressed very far despite my efforts. I have , on and off FOR A COUPLE OF YEARS, been trying to design a database to record Community Service Hours for a private school I work for. They have no money to invest in this endeavor so I have it taken on by myself and spent a LOT of my own money. Up until now, I have been using a spreadsheet. :o It is not going well. I have researched ad nauseum and for the first year I was attempting to design it in Access. yuck! I have really tried but one of the things that keeps stumping me is how to design it to break down on the service form by the students year in school (i.e. freshman, sophomore, etc.). Our service program is different than most. We require that each year a certain amount of hours are completed. (i.e. freshman = 10 hours, sophomore = 20 hours, juniors = 30 hours, seniors = 40 hours). If a student does not complete their hours, then they receive an F for the Comm. Svc grade for that year. So I must be able to see each year broken out. When entering the service hours each time, which might be 1 form for the year or 30 forms for the year per student, I do not always have their current grade. So I want to have a Service Hour input form that doesn't require I put in their current grade. I will each August update the student table with the student's information (i.e. current grade) so their record will reflect their current grade. I can obtain this information from the school database and save it to a spreadsheet and then save it to the Alpha database.
The tables that I have right now are: Students, Organizations, School year (I will input the year that the service should be credited to, 07-08),[B]Grade requirements [B](9th = 10 hours, 10th = 20 hours),Service Category(disadvantaged, disabled, elderly, environment).
I wanted to have an input form for each service verification and then have a student service record form so that I can review each student's service history broken down by year in school (9th 10th, etc.).
I have held off as long as I could before posting this message but I am starting to feel defeated. No one believes that this database will come to be. I know for you this is elementary but I am having a definite mind block that I can't seem to get over. PLEASE HELP!
Comment