Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Access TechHelp Series > Attendance Series < Employee Training Series | Accounts Payable Series >
Attendance Series
By Alex Hedley   23 days ago

Tracking Attendance for Students and Employees


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Join Now

Lessons

What's Covered

In this Microsoft Access tutorial I will show you how to build an attendance tracking database from scratch, including setting up tables and queries for your students or employees, creating a form for daily attendance entry, and generating a report to show attendance counts over a date range. This is an expert level lesson that covers continuous forms, appending records for each day, and custom date formatting, all without needing any VBA programming.

In this Microsoft Access tutorial I will show you how to improve your attendance tracking database by setting default attendance dates, using a main menu to control form defaults, creating append queries to quickly add students to the attendance table, and adding buttons to automate these tasks with and without VBA. This is part 2.

In this Microsoft Access tutorial, I will show you how to create a filtered attendance report that displays each student, their attendance dates, and groups the data to clearly show who was present and when. We will add start and end date filters to the form, build a supporting attendance query, and design a well-formatted report grouped by student. This is part 3.

In this Microsoft Access tutorial, I will show you how to add group and report totals to your attendance report, including calculating total count, present count, and absent count using text boxes and functions like Count and Sum. You will learn how to set up these totals in both the group footer and the report footer, format your report for clarity, and add a button to open the report in Print Preview. Basic troubleshooting tips for copying controls and understanding Yes/No fields are also covered. This is part 4.

In this Microsoft Access tutorial, I will show you how to sort and group your attendance report by student name and class date, and then add filtering to your attendance form using VBA so you can easily view records for a specific day. You will also learn how to use VBA to add students for a given date directly from the form and refresh the attendance records automatically. This is part 5.

In the extended cut, we will add code so that first, the button checks if you already have attendance data for the selected date and confirms if you want to add students again, and second, checks if you missed taking attendance for any previous days so it can notify you to catch up. I will show you how to prompt users before duplicating records and how to flag dates with missing attendance, including options to skip weekends and customize the date range checked.

Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

Historic

 

 

 

 

 

Series 

Links

 

Recommended Courses

Up Next

Learn More

FREE Access Beginner Level 1
FREE Access Quick Start in 30 Minutes
Access Level 2 for just $1

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates

Resources

Diamond Sponsors - Information on our Sponsors
Mailing List - Get emails when new videos released
Consulting - Need help with your database
Tip Jar - Your tips are graciously accepted
Merch Store - Get your swag here!

Questions?

Please feel free to post your questions or comments below or post them in the Forums.

KeywordsAttendance Series in Microsoft Access

TechHelp Access, attendance database, attendance report, attendance form, class date field, student query, append query, sample attendance data, continuous forms, student combo box, date formatting, ISO date format, relational combo box, active students, attendance table design, present checkbox, main menu form, criteria in query, hide combo box ID, store student attendance, attendance roster, TechHelp free template, report by date range, format date yyyy-MM-dd, count present absent, conditional reports

TechHelp Access, attendance form design, attendance default date, unbound text box default value, =Date() usage, Forms!MainMenuF!AttendanceDate, append query attendance, button to run append query, add students automatically, VBA DoCmd.OpenForm, StudentQ as data source, AttendanceAppendQ, auto-populate attendance records

TechHelp Access, attendance report, attendance form, attendance query, student grouping, class date range, report footer totals, grouping levels in report, class absences, present count, report design view, date criteria, VBA refresh, report formatting, custom report footer, student attendance records

TechHelp Access, attendance report, report totals, design view text boxes, count function, sum function, present count, absent count, report footer calculations, customer ID grouping, yes no field values, report sorting, add sorting level, preview report button, printing reports, formatting totals

TechHelp Access, attendance report sorting, group and sort reports, report design view, sort by student name, sort by class date time, group by customer id, filter property, filteron property, VBA filter attendance, openquery VBA, doCmd.openquery, me.requery, attendance append query, add students button, attendance default date, attendance filter by date, attendance append VBA, requery attendance form, check attendance duplicate, attendance missed dates check, skip weekends attendance, attendance developer tips, barcode reader for attendance, leave of absence attendance, multiple classes attendance

 

Attendance 1 Attendance 2 Attendance 3 Attendance 4 Attendance 5

Start a NEW Conversation
 
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
 
Subscribe
Subscribe to Attendance Series
Get notifications when this page is updated
 
 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2025 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/21/2025 8:54:05 PM. PLT: 1s
Keywords: TechHelp Access, attendance database, attendance report, attendance form, class date field, student query, append query, sample attendance data, continuous forms, student combo box, date formatting, ISO date format, relational combo box, active students,   Page Tag: FORUMADMIN   PermaLink  Attendance Series in Microsoft Access