
Select
“Query by person”
, as follows:
A. Student score ledger:
Show activity result of a single student in a period of time,
including activity information, individual mark and position, class average mark, etc.
B. Student answer details:
Show a single activity details of a single student
C. Student roll book:
Show attendance details for a student in a period of time,
including roll call time, present and absent times, etc.
Different form has different query condition, such as class, student, subject, activity
time, etc.
3. Query by activity
Select
“Query by activity”
, as follows: