I have been trying to figure out how to create a Swim Lesson Database using Microsoft Access.
I am more curious on how others start their design process for example:
For Swim lesson registration, you would need
Student name
student Phone#
Student Age
Parent (if any needed)
Parent # (if student needs a guardian)
amount paid
amount due
InstructorsName (table will have instructors names where this would be a drop down menu)
registration date
Swim Lesson dates(multiple Dates if more than one swim lesson is needed)
This is where I get confused
I would want to be able to input all the information above into a form and update the tables
From what I understand, I would need
StudentTbl--
studentID
studentName
studentAge
studentPhone#
--ParentTbl
parentID
ParentName
ParentPhone#
--RoosterTbl
RoosterID
RegristrationDate
SwimLessonDate
InstructorTbl--
InstructorID
InstructorName
InstructorPhone
Not too worried about the instructor table being something I need to update using a form. I can input the instructors in the table manually and have the instructors name be a drop down during the form registration.
Linking everything up where when I update the form, All of the other tables would be updated as well. I want to be able to print out reports for:
Every class so far
for specific weeks ,etc
That again wouldn't be an issue with just a simple search query.
For people who are comfortable with access or even database structures, what is your best method to design a database?