Design ?'s

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am designing my first data base. It is not too complicated. I set up my
tables and am working on my forms.


I've run into a snag. I plan to use it for an after school program.
Normally teachers fill out paper forms and some one puts into many Excel
workbooks. I thought it would be more efficient in access and hope it will
eventually all be done through email with no more paper.

I have a table for information about each school and information about the
program leaders. I have a table for information about each student. I
included in this table the questions the teachers have to answer about each
student - ie how well they get along with others, attendance, homework
completion, etc. The teachers do this 2 times a year - at the begining of
the program and the end. I am wondering if I should split this up into 3
tables? And if so use 2 seperate forms each with a subform. Maybe someone
has some better ideas.

If there is someone willing to IM with me about this - I would really
appreciate it.

Thanks
.

Relevant Pages

  • RE: Design ?s
    ... Microsoft Access MVP ... I plan to use it for an after school program. ... Normally teachers fill out paper forms and some one puts into many Excel ... I have a table for information about each student. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Tenors, Bass & Baritones and ICM
    ... I strongly agree with your observation that very few teachers teach ... whether an ICM musician intends to ... dedicated student of this music for over 20 years. ... So a Guru becomes crucial in mentoring. ...
    (rec.music.indian.classical)
  • Re: Sinfest (12/07) "Govern like its 1933"?
    ... except that all kids take the same test. ... easily will shovel your merit pay into the pockets of teachers who had ... NCLB to use the SATs to measure yearly progress in student ... administrators that can bea larger part of the problem. ...
    (rec.arts.comics.strips)
  • Re: The Guitar Teacher Project
    ... for his "academic pursuit". ... You make it sound like the student tells ... lessons with teachers that let me guide the process too much. ... I think guitar teaching, in general is in a dismal state in the USA.. ...
    (rec.music.makers.guitar.jazz)
  • Re: Interesting article by Joel Spolsky: The Perils of JavaSchools
    ... (BTW, as you probably know, I'm a college student right now, so I /do/ speak from experience. ... If they can write Visual Basic code in Java, ... Because it's completely worked out in the textbook, so it would be more profitable to copy that code for an A than work it out yourself, make a dumb mistake, and get a B. Because there are subtle issues with integer overflow that make a completely correct implementation beyond the capabilities of the average student. ... A lot of teachers are bad, but it's better that a bad teacher teach Lisp than a bad teacher teach Java, and there appears to be a shortage of good teachers at the moment.) ...
    (comp.programming)