Access Expert 15
01. Student Attendance 1 (20:12)
Types of Different Classes
ClassTypeT
Individual Class Sessions
ClassT
ClassQ with Type Name
Track Customers in Each Class
ClassXCustomerT
Class Form with Enrollment Subform
ClassF
ClassXCustomerSubF
Add Multiple Students to Class
Each Company Sends Multiple Students
02. Student Attendance 2 (31:12)
Create Attendance Table
AttendanceT
Master Attendance Form
Student Subform
Modal Popup
Default Values from Other Forms
AttendanceQ With Supporting Data
Left Joins
Create Attendance Subform
Data Entry Property
Attendance Append Query
Add Static Date Value to Append Query
CDate Function
03. Student Attendance 3 (34:59)
Create Button to Run Append Query
SetWarnings OFF
Turn on Potentially Unsafe Actions
Show All Actions
Requery
Short Date Format for Date Picker
Show Attendance for Any Date
Attendance Report By Class By Date
Sorting & Grouping
Attendance Report by Student then Date
04. Contact Archive (15:37)
Backup Contact Table
Create Contact Archive Table
ContactArchiveAppendQ
Remove Indexing Primary Key from Archive
Change AutoNumbers to Numbers
|