Hi guys, I would like to check if any of you can help with the following:
I would like to do one-time off event attendance tracking system for an award presentation ceremony using Microsoft Access. So basically, I will have a table which consists of the following fields: S/No, ID, Name, Name of Centre, Award Name & Award Value.
So before every awards ceremony, I will upload the a list from Excel with all the details of the students in it, according to the above format into the table. Thereafter, I would like to create a form where I can enter the ID of the student manually with a customised "Submit" button. Once I click on the button, it will search the other details (e.g. S/No, Name and Name of Centre) of the ID entered in the table and this record will be entered into a report. So basically only the IDs of students who have been submitted would have their details reflected in the report.
So once a record is submitted, a new form will be out and we can continue entering other student ID, using the above steps so that we will be able to know who have already attended the event. Would like to use this software to track the attendance.
I am quite new to Access and would appreciate if anyone can assist on how I can go about creating the above.