Hey, I just joined this site, but I am a new user of Access with pretty much no experience. I have been tasked with designing a database for my school's senior lunch- we sign in and out then- and I can't make any progress whatsoever. Any help at all would be hugely appreciated.
I basically have ~115 students who sign out on a paper sheet for senior lunch who all carry ID cards with barcodes that are linked to an ID number. My idea was to put into place a barcode scanner that would, when reading their ID, take them to a form that would allow them to press a button to sign in or out. These buttons would be linked to a table which recorded their times in and out, and link those with a date. I honestly have no idea what I'm doing. I don't even know if this is possible to design in access, and, if it is, I don't know where to start. Any help anyone could provide would be incredible. Thank y'all!
I basically have ~115 students who sign out on a paper sheet for senior lunch who all carry ID cards with barcodes that are linked to an ID number. My idea was to put into place a barcode scanner that would, when reading their ID, take them to a form that would allow them to press a button to sign in or out. These buttons would be linked to a table which recorded their times in and out, and link those with a date. I honestly have no idea what I'm doing. I don't even know if this is possible to design in access, and, if it is, I don't know where to start. Any help anyone could provide would be incredible. Thank y'all!