RE: Setting up a form

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

Hi David,

First off, do not store SSNs in Access. It is not secure enough.
Better to use student ID numbers, which hopefully are not their SSNs or based
off of their SSNs. If you must use the SSNs, use something like SQL Server
to store the data. And make sure you set up the security on it properly.
Also, if you must use the SSNs, do not display them on the form where someone
looking over you shoulder can see them. You might set the Input Mask of the
SSN field to "Password" so that it shows as all asterisks. Then use the SSN
field's On Got Focus and On Lost Focus events to switch between the use of
the mask and no mask so that when you click in it you can actually see the
numbers and when you click somewhere out of it, it will go back to asterisks.

That said.... I might do it this way: Create a main student form that
displays the student data. Create a book report subform that is linked to
the main student form. In that subform it will display the book report
information for the currently displayed student. Then, if I separate out the
task of reading and grading the reports from the task of entering the book
report information; and I wanted to enter new book report information
quickly, all at once; I would create a third form. This form would use just
the book report table and provide for the selection of the student, by name,
from a combo box, with the rest of the fields as text fields for entering the
book report information. It would either be a datasheet view form or a
continuous forms type form.

Hope this helps,

Clifford Bass

"David Gerstman" wrote:

Say I have a class and I want to keep track of their book reports and grades.

For every student I have a name, SSN and phone number.

For each book report I have a name, title and grade.

Does it make sense to create a form for entering the book report information
by doing a join query (on name) between the student and book report tables,
and creating a form based on that query? (So I'd select the name and the SSN
and phone would show up, then I'd type in the title and grade.)

Is there a better way to create a form for entering the book report info?

.

Relevant Pages

  • Re: encryption with python
    ... > somewhere, or at least one that unescapeably contains cleartext SSN's, ... IMO just having cleartext SSNs is questionable practice unless you ... In my experience the typical student has trouble remembering what ... > having to care about how jet engine turbopumps work. ...
    (comp.lang.python)
  • Re: Setting up a form
    ... For every student I have a name, SSN and phone number. ... For each book report I have a name, title and grade. ...
    (microsoft.public.access.forms)
  • Re: Setting up a form
    ... For every student I have a name, SSN and phone number. ... For each book report I have a name, ... The third table would be a table of reviews, with a StudentID, a BookID, ...
    (microsoft.public.access.forms)
  • Re: Too Much Consensus in the UK?
    ... student stands up and talks about a book they read and, typically, says ... Where I went to school, a "book report" was just a written appaer, with ... book report in probably fourth or fifth grade or so, ... -Aaron J. Dinkin ...
    (alt.usage.english)
  • Setting up a form
    ... For every student I have a name, SSN and phone number. ... For each book report I have a name, title and grade. ...
    (microsoft.public.access.forms)