General -
This database demonstrates data entry and report generation for an
attendance register in spreadsheet style - featuring staggered dates (i.e. working
days are restricted to two nominated weekdays)
Data Entry -
In order to retain normal structure of the table storing basic data (i.e.
student_ID, date and Yes/No field for attendance), at the same time presenting
spreadsheet style interface where attendance checkboxes are displayed in a row
across each student name, the checkbox controls on the subform are bound to an
interim table. Values entered get pushed to the corresponding checkboxes (for
particular student_ID and date)in the main table.
Before commencing entries for a new month, the user has the option to set the
nominated weekdays.
Report Generation -
The report shows attendance markings arranged horizontally against each
student. Headings for WeekdayNames & Dates for each attendance day are also
displayed.
For generating the reports, temporary table is populated on the fly , using
crosstab query based upon data filtered as per start and end YearMonths selected
by user.
Version - Access 2000
References -
Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
ADO 2.6 Download Access 2000 (ADO): http://www.rogersaccesslibrary.com/forum/uploads/37/CrossTabDemo_2K.zip - uploads/37/CrossTabDemo_2K.zip
------------- --
Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com
|