Results 1 to 5 of 5
  1. #1
    rb26dett26 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    8

    Swim Lesson Regristation

    I am trying to make a Swim lesson Database for my Instructors to be able to input new students into a class. Reports will able to print out so I can show the front desk staff to avoid people sneaking into my facility if they are not signed up for a lesson.



    I currently have

    Tables: Parents, Students, Swim instructors, Swim Lessons.

    I basically want to create a form that will ask the user to input:
    Students Name, Parents Name( If applicable since we have adult students), Instructors Name (drop down box, relationship), Date registered etc.

    The form would take these inputs and update each of the tables for their respective info.

    What would be the best approach for this? Would I need to use an update query as the form?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the list of classes/teachers.
    the class then has meet dates
    the class has a roster of students
    the class has attendance to track if the student attended
    the student is graded on the assign and graded or pass/fail


    tCourses
    -----------
    CourseID (autonum)
    subject [math, science, soc.study,etc]
    CourseType [math,sci,humantiy,music]


    tStudents
    --------------
    StudentID (autonumber)
    FirstN
    LastN
    Addr
    City
    St
    Zip
    phoneH


    tClasses (classes offered, Swim101, Dive202)
    ----------
    classID (auto)
    ClassName (Tadpoles 2pm, Sharks 4pm)
    TeacherID
    DateStart
    DateEnd
    DaysMeet (m,w,f)
    Subject
    Room#
    ClassTime



    tClassRoster (students in 1 classroom)
    --------------
    RosterID (auto)
    ClassID (long) from tClasses
    StudentID (long) from tStudents
    FinalGrade

    tClassDates (all the dates the class will meet, this list is used to populate tAttend for every student)
    ---------
    ClassID (long) from tClasses
    MeetDate
    Status (held, canceled)


    tAttend (attendance per class)
    ---------
    AttendID
    RosterID
    ClassDate
    Present (T/F)


    tTeachers
    (same as tStudents)

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I threw this together as a demo. Don't know what your dB looks like or how close I am to what you are looking for.
    If this is useful, you'll still have to develop (create) the reports and report queries.

    Good luck with your project......
    Attached Files Attached Files
    Last edited by ssanfu; 01-12-2017 at 12:15 AM. Reason: updated demo dB

  4. #4
    rb26dett26 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    8
    This is great ! thank you. really helps me wrap my mind on how everything is structured.

    A Question on the Rooster Tab, there is a student with an ID # 1 but the drop down menu to choose the student is just the Id instead of the name. Would you just link the Student ID to StudentName in the tblRooster?

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Ack!!

    In design view of form "frmRosters", open the properties dialog box for the combo box "StudentID_FK"
    Click on the FORMAT tab.
    Set properties:
    Column count = 2
    Column width = 0

    Save the form.

    I must have been really tired when I created the combo boxes...
    I normally name the combo boxes with a prefix of "cbo"...
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unclear query in Lesson 21 of Tutorial
    By Lou_Reed in forum Access
    Replies: 1
    Last Post: 05-20-2016, 06:51 AM
  2. Error in tutorial Lesson 37
    By Lou_Reed in forum Access
    Replies: 8
    Last Post: 09-28-2015, 07:42 AM
  3. Error in Lesson 28
    By Lou_Reed in forum Access
    Replies: 18
    Last Post: 08-26-2015, 02:14 PM
  4. Ambiguity in Lesson 25
    By Lou_Reed in forum Access
    Replies: 8
    Last Post: 08-19-2015, 06:42 AM
  5. I am lost on Lesson 21!
    By Lou_Reed in forum Access
    Replies: 3
    Last Post: 07-30-2015, 01:31 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums