HI all
Weird question and my skillset is limited but thought I'd try to explain this and see if theres a genius here who might be able to help/shed some light on this.
I work for a primary school and the lonely data/systems person here. I'd like ot think we try hard to utilize data as much as we can. Anyhow, we have an access database for students getting the bus when they leave for the day (90% of our 700 students get a school bus home). The database records any absences and any daily changes from the normal usage so the lists are up-to-date and every student is fully accounted for. It might seem like a small thing but If someone does or doesn't get on a bus and we are not sure where they are we have some serious issues. the database has made this so much easier as it was done on paper. It creates reports etc for student lists of those who should or shouldn't be riding on the bus or may have switched for a one-off reason.
Anyway all our attendance is done in an external system called powerschool, I can pull this data into MS Access using a ODBC link. What I want to know is am I able to pull this daily attendance info (Only the absents) into the bus database directly so it can automatically create a record as we are currently having a manual entry. This would be a huge time saver and be way more accurate than doing it manually.
I am not sure how to get it to create a record each day, I was hoping there would be a macro button I could make that would pull it in one go once I was ready.
Is this possible at all? If so there a way to explain this to a novice like myself? Any help very much appreciated.