Re: Find a row in a table from a form

You know what? Screw it. Every point each of you has made is ALREADY
part of my database or ALREADY something I considered. The important
info is NOT that a student took an exam (and no, they don't take the
same exam multiple times) but WHAT score they had. So each student has
a 1:1 relationship to the licensure or (non)licensure information.

There are no many to many relationships.

Thanks anyway for wasting my time when I had a simple question that
begged a simple answer.

"Volunteerism works when you have qualified volunteers"
--A. Mutt


Harper wrote:
I did break out the tables into single-world entities (the students
have just the information you describe) but, though I can see what you
are saying about the problem with the exams, I am having a hard time
visualizing another way to set it up. Each student's scores need to be
recorded somewhere.

I will post two of the tables as images...asking a lot, here, but can
you tell me a little how you would change the structures?

http://accesshelpplease.blogspot.com/

BruceM wrote:
Does an exam involve more than one student? If so, the exam information
should be stored once, not in the record of each student who takes the exam.
Further, if each student can take several exams, and each exam is taken by
several students, there are further considerations in setting up table
relationships. A good general rule for tables is that a table should
contain information about a single real-world entity. Name, address, phone,
Student ID, and so forth can be thought of as attributes of a person. An
exam does not fit into that category.
I agree with Lynn that your database does not seem to be normalized.
Queries, rather than multiple tables, are often the best way of sorting and
filtering data. If you insist on shuffling information between five
different tables you can probably find somebody who will tell you how to do
that, but you should also expect that the people who volunteer here will try
to steer you away from an unsound design.

"Harper" <harperwork18@xxxxxxxxx> wrote in message
news:1150398667.847545.228110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Because there is a lot more to the data than simply where they are
licensed or not. There are exams and licensing numbers attached to
licensure; there are exams attached to an unlicensed student.

I have normalized the database and that is why the data is separated
out.

Do you have a solution to the question I asked?


Lynn Trapp wrote:
Harper,
Why do you have different tables for this data? You should simply place a
couple of boolean fields in your student table that identify whether or
not
the student is licensed or unlicensed and whether or not it is an active
(archived) student.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



"Harper" <harperwork18@xxxxxxxxx> wrote in message
news:1150395999.754294.237510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
I am making a database where there is a form where the user can select
whether an education grad. student is unlicensed or licensed. Nearing
the end of the program, their status does change (we hope) from
unlicensed to licensed. Also, the student's status may change simply
because the user may have mistakenly assigned the wrong status.

I have table STUDENT, table LICENSED, table UNLICENSED, table
LICENSED_ARCHIVE, table UNLICENSED_ARCHIVE among others. In form
STUDENT_ENTRY, I have a combo box with "unlicensed," "licensed," and
"unknown" and text boxes, one of which is IDNo (their student id
number). The IDNo is the primary key through the tables.

When the user changes the combo box from one type of status to another
(excluding "unknown," for which nothing happens), I would like to have
access 1.) look up the IDNo field, 2.) Find that IDNo in the original
table, the table that corresponds to the status the student is being
switched from 3.) Copy that row into table LICENSED_ARCHIVE or
UNLICENSED_ARCHIVE as the case may be 4.) Delete said row from original
table.

I understand how to do an append query and delete query so I have 3.
and 4. covered. But I am stuck at 1. and 2. I do not know VBA so if
there is some kind of solution I can understand using expressions or
whatnot, I'd be grateful.

Thanks much,
Harper



.

Relevant Pages

  • Re: Find a row in a table from a form
    ... Not every response is on target, ... response you would know that my question was whether the same exam could ... taken by multiple students, not whether each student took the same exam ... a 1:1 relationship to the licensure or licensure information. ...
    (microsoft.public.access.forms)
  • Re: Find a row in a table from a form
    ... aware this is a volunteer group. ... response you would know that my question was whether the same exam could be ... taken by multiple students, not whether each student took the same exam ... a 1:1 relationship to the licensure or licensure information. ...
    (microsoft.public.access.forms)
  • Re: Find a row in a table from a form
    ... aware this is a volunteer group. ... response you would know that my question was whether the same exam could be ... taken by multiple students, not whether each student took the same exam ... a 1:1 relationship to the licensure or licensure information. ...
    (microsoft.public.access.forms)
  • Re: Multiple choice answer tracking and exam tracking
    ... But you do need a related table that gives you a *record* for each question the student attempts, instead of a *field* for each question in one big wide table. ... whether the student gave the correct answer to each question in the exam. ... Allen Browne - Microsoft MVP. ... > intention of the database. ...
    (microsoft.public.access.modulesdaovba)
  • SQL to return data including missing data?
    ... I have an Exam table that consists of three fields, Student, Question ... the Exam table may omit some Candidates or some Questions for a ... experimenting in Access but the final database will be Apache Derby ...
    (comp.databases)