nOOb question - Not sure I'm even using the right program.

[tray262]

Hello all,

I'm completely new to the access world. I'm not 100% sure I'm even thinking about this correctly, but I'm really trying to come up with a good solution to my issue. I can explain what I need in the end and what I think I need to do after doing a ton reading and watching beginner videos on Access.

What I'm looking for: Student growth tracker (Kind of like a grade book)

Info that will be collected (tables):
Student Info: First, Last, email, etc
Assessments: Name of assessment, max score, description, standard, etc.
Standard: Name, description
Score: Each student will get a score for each assessment (defaults to 0), spot to attach a artifact (scanned assignment)

Input: This is where I'm going to show I'm a nOOb, I would love to have a "form" that looks like spreadsheet; assessments across the top (columns), students down the side (rows). I could simply click in the intersecting cell and it will create a record in the scores table referencing the studentID. I would like to make it so I could double click in the cell to add to bring up a details page for that students score on that one assignment. This would allow me to attach a file and add a note to it.

Reports: I need to run various reports.
1. Student report: this will pull the data the scores. So it will have Student name at the top and create a sheet that will pull all of the assessments from one "standard".
2. Assessment report: this will put a report of each assessment and give me a list of the students that scored a 1, 2, 3, 4, etc.
3. Maybe more details later......

I'm hoping I'm thinking right. I think it's just a matter of process. The part I'm getting hung up on is making the "easy" input sheet. I think I could get it to work if I wanted to input each assessment score one at a time.



I really need when I add an assessment it adds automatically adds a score for each student set to zero. Just not sure I'm doing this right.

Thanks,
Tray262

[Dal Jeanis]

You're in the right forum.

Suggestions -
1) You are likely to enter your data in batches - either several assessments for one student or the same assessment for several students.
As such, you can build two versions of a continuous form that allow easy entry of either multiple assessments for one student, or the same assessment for multiple students.

2) Don't worry about "zero" records - You don't have to store non-events. Any assessment that has not been done will automatically have a zero value. You can handle that in the queries.

[Dal Jeanis]

By the way, for general tutorials that will help you know how to think about database design, check out Roger Carlson's tutorials at http://www.rogersaccesslibrary.com/. Very good info, easy to pick up, and has a few sample problems to work through.

[tray262]

Where is the like button for your last post? lol. Thanks!!!!!! "continuous form" That's what I need to work on and research.......... I'm such a backwards planner. I want to jump right in to the reports and run, but I want to make sure I'm building this right.

[Dal Jeanis]

The little sherriff's badge adds to a poster's reputation. I think it can subtract, also, but I've never seen that done.

|
|
|
V

[tray262]

By the way, for general tutorials that will help you know how to think about database design, check out Roger Carlson's tutorials at http://www.rogersaccesslibrary.com/. Very good info, easy to pick up, and has a few sample problems to work through.

Do you have any good resources for creating a "continuous form"? or do they go by a different name?

[Dal Jeanis]

You already use them.

It just means a form where the Detail section is allowed to repeat once (vertically) for each record in the underlying query, rather than displaying only one record and using record selector arrows at the bottom to move between different records.

You build the detail section to display a single record, then set the
Form properties -> Default View - Continuous form instead of Default View - Single