Mattiekrome
Technical User
Hello again. I have been building an excel spreadsheet that will be used to track class attendance. It was working well, until I started trying to track additional information such as addresses (inside of excel comment fields). I am now thinking of scrapping this original idea and look for a new solution. Just getting too big to fit in a spreadsheet (not to mention the problems with my comment fields and frozen panes... argh!)...
Does anyone out there have any suggestions on how to go about this in access? The fields will include (a general idea...):
First name
Last name
Middle initial
Address
City
State
ZIP
Email
Birthdate
etc.
This class will be meeting one time per week. The whole point of this database is to be able to somehow enter whether or not a certain person was in class each week. Once I get several weeks of attendance info entered, I would like to be able to generate a report (with address and phone #) based on who has missed 3 classes in a row.
The biggest thing that I am unable to grasp is how to enter the attendance part. Will I have a field for each week (class meets once per week)? If so, will I have 52 checkboxes on a form (once for each week of the year)? Seems like it would be a little cluttered, lol.
I thought of putting 12 tabs (one for each month) and then having the 52 class meeting days (checkboxes) on said tabs. The drawback of this is all the clicking that has to be done to get to the correct person, then find the correct tab, then put a checkbox on the correct date. Multiply that time 100 people each week and it can become quite time consuming :/
I thought of just entering the attendance data straight into the table, but with the 60+ fields that will be included, it could get a little frustrating. Then I thought of maybe using the form, but adding a search box, where you could type in the first few letters of someone's last name and go straight to their record.
And to make it all more complicated, I will be sharing this "attendance duty" with another older woman who isn't a huge fan of PC's or learning to do anything new with PC's. So it might have to be somewhat user friendly to top it all off.
I have some experience with Access in the past, but its been literally YEARS since I've had to tap into the ol' brain on this sort of thing. I'm sure once I got a plan and got my hands on the tables, I could get something going.
Maybe there is no real simple way to do this, but I thought I would ask, since lots of the posters on here work with this sort of thing everyday. Advice, insight, and direction are greatly appreciated! Thanks!
Does anyone out there have any suggestions on how to go about this in access? The fields will include (a general idea...):
First name
Last name
Middle initial
Address
City
State
ZIP
Birthdate
etc.
This class will be meeting one time per week. The whole point of this database is to be able to somehow enter whether or not a certain person was in class each week. Once I get several weeks of attendance info entered, I would like to be able to generate a report (with address and phone #) based on who has missed 3 classes in a row.
The biggest thing that I am unable to grasp is how to enter the attendance part. Will I have a field for each week (class meets once per week)? If so, will I have 52 checkboxes on a form (once for each week of the year)? Seems like it would be a little cluttered, lol.
I thought of putting 12 tabs (one for each month) and then having the 52 class meeting days (checkboxes) on said tabs. The drawback of this is all the clicking that has to be done to get to the correct person, then find the correct tab, then put a checkbox on the correct date. Multiply that time 100 people each week and it can become quite time consuming :/
I thought of just entering the attendance data straight into the table, but with the 60+ fields that will be included, it could get a little frustrating. Then I thought of maybe using the form, but adding a search box, where you could type in the first few letters of someone's last name and go straight to their record.
And to make it all more complicated, I will be sharing this "attendance duty" with another older woman who isn't a huge fan of PC's or learning to do anything new with PC's. So it might have to be somewhat user friendly to top it all off.
I have some experience with Access in the past, but its been literally YEARS since I've had to tap into the ol' brain on this sort of thing. I'm sure once I got a plan and got my hands on the tables, I could get something going.
Maybe there is no real simple way to do this, but I thought I would ask, since lots of the posters on here work with this sort of thing everyday. Advice, insight, and direction are greatly appreciated! Thanks!
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red][/red]![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]