See my updated Append Query video!
Microsoft Access Append Query
Using an Append Query to Add Records to a Table - Track Student Attendance
Q: I have a class full of students, and I need to be able
to keep track of their attendance on a daily basis, and I have to be
able to save a history of the data for the entire school year. What is the best way
to do this in Access, keeping in mind that ease of data entry is
a must, since I have a lot of students?
A: This can be done with a
couple of tables and an append query. It's much easier to show
you than to type it out, so watch this FREE VIDEO TUTORIAL
for complete step-by-step instructions:
I teach more about Append Queries in my Access Expert Level 14 course.
By Richard Rost
Click here to sign up for more FREE tips