Avatar of amyamo
amyamo
Flag for United States of America asked on

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

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
Microsoft Access

Avatar of undefined
Last Comment
Member_2_861731

8/22/2022 - Mon
Member_2_861731

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.
amyamo

ASKER
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?
Member_2_861731

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?
Your help has saved me hundreds of hours of internet surfing.
fblack61
amyamo

ASKER
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
Member_2_861731

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
amyamo

ASKER
Thank you!!
 I'm going to check out the database you posted now
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
amyamo

ASKER
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
ASKER CERTIFIED SOLUTION
Member_2_861731

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question