Microsoft Access: Tracking Student Attendance, Append Query

In this Microsoft Access tutorial, I will show you how to use an Append Query to track student attendance in classes. We'll create a couple of tables and a form, then use an Append Query to transfer the data from our student table to our attendance history table. I'll also throw in a little VBA code just to spice things up.

Category:

Howto & Style

Tags:

• microsoft
• access
• query
• append
• action
• vba
• queries

[dosattack777]

great videos; can you cut me a deal like on all the access videos you have? I wanna purchase some.

[599CD]

If you visit the web page URL at the end of the video, you will get a 50% discount on all of my Access tutorials... special only for YouTube viewers.

[stonecolly]

awsome



[nicolpears2]

thanks so much for posting! awesome. I went to the site you listed to watch the rest of the video but i can only hear the audio no video is shown. I checked my system requirements. I have Windows 11 and latest version of internet explorer and firefox. I don't know why i cant watch it (i tried different laptops windows & mac). I am stuck in the middle of trying to finish appending query. help please

[artche20]

nice..



[abdulrab2010]

great, but i created a register then i tryed to re-write the register again for the same day, instead of writting over it the database created a new record for the same day.

[mkpsr45]

i like this...i am a teacher in training and will definitely use this approach. the steps are really clear! good job

[pkwajed]

thank you very much for uploading sir its useful...........

[alfin200605]

hello. i have a question in yes or no field. example a group of people votes for yes or no. and all of them doesn't have the same answer. my question is, how will you know how many people says yes or no in access 2007. please help.

[gtiyg]

How do you clear the check boxes in access 2007 using the button after the forms is saved?