Which Form 8655 Attendance 2024

Welcome to a free Tips & Tricks learning video brought to you by Access Learning Zone. I am your instructor, Richard Ross. In today's lesson, we're going to cover tracking student attendance in classes using action queries. One of my customers sent me an email saying that he has to track attendance for students in his class and he wants to be able to have a list of students and then type in the date and just simply go down and check off which students were in attendance. And since he has to do it every single day, ease of entry is a must. So here's how I would solve this problem. First, I would create a blank database called "student attendance." Let's create a table for our students. Real quick, go to tables, new design view, then hit OK. Add "student ID," which is an auto number. Normally, I would include more data like first name, last name, and address, but for now, I'll just include "student name" as a text field. Next, I'll add a temporary attendance field as a yes/no value. This will allow me to easily check off whether or not each student is in class each day. Then, I'll use some action queries to move that information into a historical table. Let's create that historical table. Save the table and name it "student T" for student table. Access will automatically assign the student ID as the primary key field. Now, let's create a table to save the historical data. Each day, I'll record whether or not the student was present in class. Create a new table, go to tables, new design view. This will be my attendance table. Add "attendance ID," an auto number field. Add "student ID," which will relate back to the student...