Database for IB ITGS

[msmith20]

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!

 

[msmith20]

Thank you! Would it be possible for the database to register the scanning as also pressing the button, so that the student would not have to click a button at all?

 

[Deleted member 147267]

This is just an opinion, but if you're really new to Access, then you have been given the keys to the car without ever having observed anyone driving before, let alone had driving lessons - and there's plenty of 'not so good' advice to be found. Access has a substantial learning curve and I'd recommend some research before starting your engine. If that doesn't describe your experience level, then I missed the boat again.

Regarding your db, if there's no worry about students loaning cards, and the cards id the student, then why not just have the db log their coming and going (via scanning) without any other interaction from them?

 

[msmith20]

Regarding your db, if there's no worry about students loaning cards, and the cards id the student, then why not just have the db log their coming and going (via scanning) without any other interaction from them?
[/QUOTE]
That would definitely be better. To your earlier point, I've spent a while watching youtube and such to try and learn the basics, and I have a teacher supervising who is pretty proficient in this, but I am supposed to figure most of it out on my own. I'm going to try to figure out some basic VBA or macro stuff and see if I can make it do what I want. Thank you!