Re: subform entry limited to (n) fields?
From: PeterN (PeterN_at_discussions.microsoft.com)
Date: 01/04/05
- Next message: Jeff Boyce: "Re: auto-fill a textbox"
- Previous message: Bijal: "Re: Creating a Form (or Subforms) from 3 tables"
- In reply to: John Vinson: "Re: subform entry limited to (n) fields?"
- Next in thread: John Vinson: "Re: subform entry limited to (n) fields?"
- Reply: John Vinson: "Re: subform entry limited to (n) fields?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 Jan 2005 03:03:04 -0800
John, I'm at a Road block.
the tbls are designed as follows:
Student:
StudentID, FN, SN, DOB, etc
Subject Table:
SubjectID, Subject (spelling, reading, writing, etc)
Assessment Table:
AssessmentID, SubjectID, WeekNumber.
NB:cut back due to problems at present - I will use the date field.
Result Table:
ResultID, StudentID, AssessmentID, Score
I've played around with the relationships and I can get a query to send out
some good data. But I'm stuck on designing a form that will allow me to see
words not ID numbers for various inputs so that data can be stored. Ideally
each week I'll enter a range of marks for each student. I have this working
in another file but it has the wrong design in table structure. So now I'm
land locked and confused. I'll go back to examples like Northwind and others
tomorrow but any ideas would be appreciated. I'm really in the mud with this.
PeterN
"John Vinson" wrote:
> On Mon, 3 Jan 2005 14:27:02 -0800, PeterN
> <PeterN@discussions.microsoft.com> wrote:
>
> >Yes John,
> >After several tutorial style books about Access and the Function X Tutorial
> >which I thought were excellent and trawling the web for education based apps
> >for Access and talking to you I'm starting to see how the data is organised
> >differently than a spreedsheet which I have been using for this sort of thing
> >for years. When I read your response yesterday I looked at the Students and
> >Classes database from A'97 and its seems to be doing what you suggest.
>
> Absolutely. Spreadsheets are NOT relational databases; and applying
> spreadsheet logic to a database is pretty sure to get you a bad
> design!
>
> >As it stands now Ive got a Student table (given)
> >
> >SubjectTable - SubjectId, SubjectName,Strand( in Australia these are things
> >like reading, writing , etc in the subject of English)
>
> reasonable
>
> >Assignment Table - AssignmentId, Description(this is were Week# Spelling
> >could go??) and subjectID
>
> I'd have separate fields for the week number (without using the
> special character # in the fieldname) and the text description. I'd be
> inclined to include a Date/Time AssignmentDate field though (in
> addition to, or even instead of, the WeekNumber); Week 3 is ambiguous
> if your database is to be useful during a second term.
>
> >and
> >ResultTable - ResultID, StudentID, AssignmentID and Score(Mark)
> >
> >How does this look to you?
>
> Getting there! Looking good actually.
>
> >Also John do you know of any Education based books that would help me. Most
> >books I flip through now I find I know how to do the Access skills set to a
> >high level But developing my own application has been challenging.
>
> Not right off hand. Yes, Access database development *is* challenging;
> the learning curve is much steeper than that for Excel. There are many
> good general books out there, but I don't know of any tuned
> specifically to educational applications. Your countryman Allen Browne
> (http://members.iinet.net.au/~allenbrowne/tips.html) has some good
> links and suggestions, though.
>
> John W. Vinson[MVP]
>
- Next message: Jeff Boyce: "Re: auto-fill a textbox"
- Previous message: Bijal: "Re: Creating a Form (or Subforms) from 3 tables"
- In reply to: John Vinson: "Re: subform entry limited to (n) fields?"
- Next in thread: John Vinson: "Re: subform entry limited to (n) fields?"
- Reply: John Vinson: "Re: subform entry limited to (n) fields?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
