Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Course Databse Add multiple Students on One Form

  1. #1
    Board Regular
    Join Date
    Sep 2008
    Posts
    276
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Course Databse Add multiple Students on One Form

    I have a database that we are tracking student enrollments and graduation certificates. I am trying to update the database to where we can input all the students for a course on one form. Generally students will arrive all at once and then we in-process them so being able to input all students (20 at the max) on one form would be awesome.

    Just looking for someone to point me in the right direction and I will build from there. Also using Access 2013.

  2. #2
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,101
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Course Databse Add multiple Students on One Form

    You could create your form in datasheet view. All at once is a relative term. You probably would still have to go student by student, so time-wise not a huge difference.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  3. #3
    Board Regular
    Join Date
    Sep 2008
    Posts
    276
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Course Databse Add multiple Students on One Form

    I basically want all the class information to be filled in and then probably in a subform to be able to enter all the students information in the class. I dont want to have to enter all the course information 20 different times.

  4. #4
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,101
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Course Databse Add multiple Students on One Form

    That is handled with relational tables. You have one course record that is related to many student records. You might then implement a subform/main form (but I would probably just have a foreign key in the student form - i.e., just add one more field for ClassID).

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  5. #5
    Board Regular
    Join Date
    Sep 2008
    Posts
    276
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Course Databse Add multiple Students on One Form

    I have all the tables built already and they work, I am just not up to speed on form design. I basically want my my form to show at the top the course name, start date, and end date, and then at the bottom of the form I want to be able to enter student information. The way I know how to do it would they would have to go to a new record and enter all the course name, start date, end date over each time along with a new student. I would rather have the upper portion either stay the same until you enter all your students on different records or enter all the students on one form without having to switch back and forth.

  6. #6
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,101
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Course Databse Add multiple Students on One Form

    Just for starters, you should be able to enter the student information with a class ID (not all the class information).

    You can also build a subform/mainform setup. Assuming you have table relationships set up with the primary keys and foreign keys. A forum is not the best place to go over all that - it would require a lot of typing (by me) and that's not necessary since there are a wealth of youtube videos and web tutorials about building access forms. However, if you do want the short version, it's probably something like create the main form (class ID). Drag into or create a subform (students). Then hook up the parent-child relationships between the main form and subform in the properties (I guess the subform properties).
    Last edited by xenou; Dec 6th, 2018 at 11:57 AM.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  7. #7
    Board Regular
    Join Date
    Sep 2008
    Posts
    276
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Course Databse Add multiple Students on One Form

    Correct, but that still multiple input for something, if it can be done should only have to be entered once. If it cant be done I am okay with that, but when you have a team that doesnt like technology so designing something that would involve them changing their normal processes, I want to have the least amount of steps possible. If I was still running a website with SQL it would be easy, but I no longer have that option.

  8. #8
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    16,101
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Course Databse Add multiple Students on One Form

    As I said, you can use a main form subform setup among other solutions. You can also populate the foreign key without typing if you like. All this is common stuff for Access. I recommend you you just jump in and start working it out. I don't find it onerous to enter a class ID but its not something that's required.

    By common stuff, I mean the general issue is "how to enter record with a foreign key". You should be able to find examples I think if you do a little googling. You said you wanted to be pointed in the right direction and this is what I have been pointing you towards.
    Last edited by xenou; Dec 6th, 2018 at 02:03 PM.

    Using: Office 2010/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •