Is this possible with a database?

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

I've asked this many times and whilst i have had replies, i haven't had
answers, so i'm am coming to the conclusion it can't be done with a database

i have a database that controls the lions share of admin in a classroom -
from generating invitations to enrole thru course tracking thru weekly
statistics - thru to letter of congratulations on successful completion

but i still have to use a spreadsheet to monitor daily attendance which i
cannot integrate into the database - i have to generate it manually every
week & retype it in manually (and inaccurately) into the database every
month end

i actually need a query (read/write) that can generate a grid of checkboxes
using a list of active students (field values - not field names) vs the
current calander month in dates (again values and not field names) -
spreadsheets do this so easily but some sort of crosstab i expect (the more
i read about these, the less i seem to know)

this would mean i could input attendance once only and from that generate
more accurate statistics (potential vs actual attendance - excuse the
teacher talk)
 
i've looked through the templates quite few times - but an attendance
register seems beyond the scope of most m/s applications

funny - because you would think it quite a popular request - i expect it's
one those things that can only be found in the domain of professional apps
 
I'm not sure where your problem is. You can keep a temporary table with
fields for student ID, start date, and check boxes (yes/no fields) for some
number of dates. Append the student ID and start date (and maybe class) to
the table and check boxes as necessary. When the user is finished, use code
or queries to append the un-normalized temporary data to normalized tables.
 
I do not know if you have solved your problem yet. I had to do something
similar for my school. This is what I did:
Create a table with a date field [Attendance Date], [Student ID] and
[Attendance Code]. [Student ID] is the field linking to the Student personal
data and [Attendance Code] is the field linking to the attendance code
descriptions.
Create a form where the date is entered once and just add the student id's
and attendance codes.
Once the table is populated with the data, use it to create a parameter
query that asks for a date range and create a group report based on this
query. Your report may have the dates as rows rather than columns (my
attendance office can live with it).

good luck.
 
Back
Top