B
Bob
I created a simple database a few years ago for the nurse in my school. The
design has worked up until now. Other nurses have heard about this and I
have been asked to do something which I cannot figure out how to do.
I have a table, Students, in which the following is stored:
ID: text, key
FirstName: text
LastName: text
Homeroom: text
Fluoride: yes/no
I have a query of the Students table so I can create a list by homeroom of
those who receive fluoride.
In a report, I call the query, enter the homeroom name and have a list of
that homeroom's students who receive fluoride.
Simple and no problems.
Now I am being asked for two other features:
1. the report to include a "spreadsheet-like" grid to be used as a checklist
by the teachers. The idea is that the report will now contain a checkbox for
each week of the school year that the teacher will mark (on paper) whether or
not the student received his fluoride.
2. each year students are promoted to another grade and assigned a different
homeroom. Rather than re-enter all this, I somehow need to get the fluoride
flag in on the new data.
#1. I seem to be inept in creating a report that contains information other
than what is culled from the query. How can I add checkboxes to print on the
report that are not bound to anything?
#2: What I have done up to this point is import a new table of students each
September. This contains many of the same students as last year, but each
has a different homeroom assigned. I have then, because it is easy enough
for me to rip through, added the flag for each student from last year's data.
Obviously, this is not a good way of doing this.
I imagine an update query of some sort would work, but I do not know how to
go about that. Would someone be able to walk me through this process? I am
a beginner without a good handle with Access.
Thank you.
design has worked up until now. Other nurses have heard about this and I
have been asked to do something which I cannot figure out how to do.
I have a table, Students, in which the following is stored:
ID: text, key
FirstName: text
LastName: text
Homeroom: text
Fluoride: yes/no
I have a query of the Students table so I can create a list by homeroom of
those who receive fluoride.
In a report, I call the query, enter the homeroom name and have a list of
that homeroom's students who receive fluoride.
Simple and no problems.
Now I am being asked for two other features:
1. the report to include a "spreadsheet-like" grid to be used as a checklist
by the teachers. The idea is that the report will now contain a checkbox for
each week of the school year that the teacher will mark (on paper) whether or
not the student received his fluoride.
2. each year students are promoted to another grade and assigned a different
homeroom. Rather than re-enter all this, I somehow need to get the fluoride
flag in on the new data.
#1. I seem to be inept in creating a report that contains information other
than what is culled from the query. How can I add checkboxes to print on the
report that are not bound to anything?
#2: What I have done up to this point is import a new table of students each
September. This contains many of the same students as last year, but each
has a different homeroom assigned. I have then, because it is easy enough
for me to rip through, added the flag for each student from last year's data.
Obviously, this is not a good way of doing this.
I imagine an update query of some sort would work, but I do not know how to
go about that. Would someone be able to walk me through this process? I am
a beginner without a good handle with Access.
Thank you.