Form to allow easy check off of people who attended a course

G

Guest

Hi,

I am designing a database for a client and just wondered if you have
designed a database form like the one I am about to describe and if so, could
I take a look at it or what do I need to do to build the form or perhaps some
site I can go to to see how its done?

The part of the database I am working on now concerns 3 tables: a list of
courses, a list of persons, and a list of persons and what course they
attended.

The user has a paper copy of a course and a list of persons signatures who
completed that course on a certain date. Rather than having the user go into
the list of persons who completed a course and have to, one at a time for
each student who attended the course, pick the person, pick the same course,
pick the date attended....I would like a form whereby the user easily picks
the course once, picks the date attended once, then easily marks a check box
next to each person who attended the course, then clicks a button and as a
result, all the records of people who took that course on a certain date are
filled in the table that contains the list of person and what couse they
completed.

Thank you very much

Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A form to easily check off people who attended a course 2
Copying Data from a subform to another form 0
Showing two fields from one table in one field on another 2
Query logic? question 2
Saving information to a table field 5
Managing a list of events 3
Access linking new student form to new course form 2
Duplicate value check 9

Top