Re: Easier Way to Change My Controls

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 16:14:06 -0700

On Fri, 27 Feb 2004 11:44:38 -0800, "Chaplain Doug"
<anonymous@discussions.microsoft.com> wrote:

>Dear John:
>
>My "grades" also include 24 dates of unit completion:
>e.g., GEN 1, GEN 2, . . .,GEN 8, GEN UNIT 1(Date of
>completion). There are 24 units of 8 lessons each.
>Anyhow, my current table has all info (Student and 24*9
>fields). I am confused as to how all of this new table
>design (non-spreadsheet) will work. Can I communicate
>with you directly via email? I am at dpp@comcast.net.
>God bless and thanks for all the help.

I'd be willing... but only with a consulting contract in hand, I fear.
I'm an unpaid volunteer here, like everyone else, and as such I must
reserve private EMail support to paying customers.

That said...

it sounds like you should have a 24-row table of Units, and a 192-row
table of Lessons, with (perhaps) three fields - Unit, LessonNo (1 to
8), and a Description field explaining what's covered in GEN 2 (I'm
guessing that's Genesis? Would you be willing to share your lesson
material on Mark 14-15 for the Bible study class I'm teaching? <bg>)

Your Grades table then might better be called a Completion table if
you're storing completion dates. It would have four fields:

StudentID as a link to the Student table (who completed the lesson)
Unit
LessonNo together form a link to Lessons, which lesson they did
CompDate The date that they completed this lesson

You could have a Form based on the student table, with a subform based
on the Completion table; this would show - on one line per lesson -
exactly which lessons were completed when by each student.

This gives you a much simpler form design than trying to wrestle with
216 controls!

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Relevant Pages

  • Private Lesson Policies - Comments and Critique Are Welcome
    ... I offer insights into several important key areas of jazz - the ... I provide material that helps the student develop versatile ... Lesson material will be tailor-made and well-prepared in advance ... Instrument and materials: complete and in working order and shape. ...
    (rec.music.makers.guitar.jazz)
  • Re: Easy for you, Difficult for me: Help a school
    ... Student table, ... Lesson table, ... Teacher table, ... e) SessionStudent table ...
    (comp.databases.ms-access)
  • Second Ground Lesson to that student that looks like my CFII
    ... I was all ready to do my ground reference maneuvers presentation and John ... asked me if I was ready to first give a ground lesson on taxiing. ... those physical skills that you had to practice. ... student needs to do is start taxiing away.. ...
    (rec.aviation.student)
  • Re: Private Lesson Policies - Comments and Critique Are Welcome
    ... tradition - jazz, pop/ rock. ... I provide material that helps the student develop versatile ... Lesson material will be tailor-made and well-prepared in advance ... Instrument and materials: complete and in working order and shape. ...
    (rec.music.makers.guitar.jazz)
  • Just a mild confusion about my CFI training
    ... of stalls, slow flight, steep turns and 'why we are practicing them',,, etc. ... The next lesson day I teach an in-flight lesson to the student. ... Like the best way to communicate ...
    (rec.aviation.student)