Solved

Best Way to start creating a form out of multiple tables?

Posted on 2011-03-05
8
389 Views
Last Modified: 2012-05-11
I am trying to create a form out of multiple tables. I have attached a PDF of what I want the form to look like. I'm confused as to how to go about building parts of it and getting the classes to work with the attendance and departments.

An instructor will fill this form in. They will enter in the student name, their attendance, their grades and any comments. I will then need to make the amount of absences ("A") total into the "Att" field and the average grade for each class total into the "Train Avg" field.

Any help on how I should go about building the Attendance and Grading areas is appreciated.
thank you
sampledb0311.accdb
Students.pdf
0
Comment
Question by:amyamo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 13

Expert Comment

by:LIONKING
ID: 35043995
In my personal opinion you should create different forms for saving different information.
For instance, you could create a form to register student information, one form for attendance, one for grading and commenting. If you do this you would have a cleaner UI and something easier to work on.

I'm not saying it's impossible to do it all in a single form, but it will be a lot more work.
0
 

Author Comment

by:amyamo
ID: 35044017
I would be fine with creating different forms, my problem is how to create each form. For instance, the attendance form - The tables to create this are the attendance and classes. I made a junction form that links the two for the many-to-many relationship - how do I go about creating the areas that the instructor will enter either "X", "T", or "A" into?
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 35044165
In what table do you save the values "X", "T", or "A"? Because if it's in the attendence_classes table I think you're missing a field there... And I don't see the date field either, or are you just gonna save the name of the day?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:amyamo
ID: 35044274
You are absolutely correct, I didn't have either of those in there. I added them now and am reposting my database.
Are you able to point me in the right direction now for creating the form for the instructor to enter the attendance each week for each class for each student?
thank you

sampledb0311.accdb
0
 
LVL 13

Expert Comment

by:LIONKING
ID: 35044431
You still need to add the studentID to the Attendance_Class table, otherwise you're just saving the attendance for a specific class on a specific day, but no student involved.

Check out the form I added to your database, all I did was change some textboxes to combobox. Once you do this you change the rowsource property to a query (querying the table with the ID and description fields), and you establish the dependant column to the ID column (number, not name). After that you'll be able to select from dropdowns, instead of having to memorize the codes.

Check it out and let me know if this helps as a start point for what you want. sampledb0311.accdb
0
 

Author Comment

by:amyamo
ID: 35046581
Thank you!!
 I'm going to check out the database you posted now
0
 

Author Comment

by:amyamo
ID: 35046620
I looked at the form you created, thank you-
but the problem I'm having is trying to figure out how to get it to look like I want. if you look at the PDF I had originally attached - I want to be able to show all of the days of the week going across and then the classes listed vertically - I don't understand how I can take what you did for me and have all of the fields available for the instructor to enter in the AbsentChoice - Do I need to create something new for each day and class?
thank you
0
 
LVL 13

Accepted Solution

by:
LIONKING earned 250 total points
ID: 35056769
I don't know if you can make the form that way using only the form assistant, because that would mean one of two options:
a. Having static classes for each student, hence having the labels statically placed in the form, or,
b. Having to dynamically create the labels (downward) and textboxes for each class the student signed up to.

Option A should not be considered because that would limit the number of classes each student could have. And option B would require some coding to dynamically create the labels and textboxes/dropdowns, and you'd also have to dynamically create the SQL sentence to insert the data according to the classes.

I'm not saying that what you want is impossible, I'm just saying that by code it would be pretty tough to achieve. And unless another expert knows if you can make like a pivot table (or cross-tab) to insert your data, I'm pretty much out of ideas on how to get what you want with your form.
Sorry for not providing a helpful solution here.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question