CrossTabDemo_2K.mdb

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): uploads/37/CrossTabDemo_2K.zip