i have a good 'schema, where do i go from here?

[jase118]

Hi, I have used this and many other forums to develop what i believe is a good table layout and have established my relevant relationships between the tables.
My knowledge of Access is limited (i have built DB's but a long time ago).
I am now trying to build the second phase of my database, the queries.
My DB is a water sports booking system and we are run on a low budget so i can not afford to get this done professionally.
The functionality i need is to:
Add/remove Courses
Add/remove Sessions to the courses (a course may run 5 sessions a year)
Add/remove members to each course

I require a lot more functions down the line but this is the basics of my DB.
I am not sure were to start with bringing all the tables together to get the desired results.


This is my table layout:
tblMembers
-pkMembersID
-txtFirstName
-txtLastName
-fkRank
-txtNumber
-txtAddress1
-txtAddress2
-txtCity
-txtCounty
-txtPostcode
-txtMil
-txtTel
-txtMobile
-txtEmail
-ActivInd

tblRank
-pkRankID
-txtRank

tblCourses
-pkCourseID (1 to many link to fkCourseID)
-fkCourseType
-numMax (maximum places available on the course)
-curPrice
-logIsAvailable

tblCourseType
-pkCourseTypeID (1 to many link to fkCourseType)
-txtCourseType

tblSessions
-pkSessionID (1 to many link to fksessionID)
-dteStartDate (session start date)
-dteEndDate (session end date)
-fkCourseID

tblSessionMembers
-pkSessionMembersID (1 to many link to fkMembersID)
-fkSessionID
-fkMembersID
-logPaid
-logInstructionsSent
-numPlacesRequired

Where do i go from here?

[TheShabz]

Look up the INSERT INTO, and DELETE FROM sql structure. That should give you a good start. What will most likely end up happening is that you will create a form and use that to enter data. so lets say you want to create a new course using textboxes in a form. syntax would be (assuming courseID is a autonumber field):
INSERT INTO Courses (fkCourseType, numMax, curPrice, logIsAvailable)
VALUES (Forms!myForm!txtCourseType, ....)

That's if you would be doing it in the query builder. If you end up doing it in VBA (more powerful and my preference) you would have to create a string holding the sql before you can run it. You will need to look up concatenation, the "firstpartofstring" & variable & "last part of string" form. for the variable, instead of Forms!myForm!txtCourseType, you would have Me.txtCoursetype where txtCourseType is the name of the control (textbox in your form) that holds the value you wish to insert into your string.