A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old June 6th, 2010, 11:23 AM posted to microsoft.public.access.tablesdbdesign
jase118 via AccessMonster.com
external usenet poster
 
Posts: 3
Default i have a good 'schema, where do i go from here?

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?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201006/1

Ads
  #2  
Old June 6th, 2010, 12:33 PM posted to microsoft.public.access.tablesdbdesign
Jörn Bosse[_3_]
external usenet poster
 
Posts: 20
Default i have a good 'schema, where do i go from here?

Well,

now you should start creating forms. You may start with the forms for
members. Creating a new one/editing onformation/deleting members.
The you do the same thing with the courses and sessions etc.
When you´re about to design a form and you have a field in it with a
foreigt key, use a combobox to select this value from original table.
For exaample fkRank in tblMembers needs a combobox in a form with the
tblRanks as rowsource. In this combobox you can set the width to 0 for
the first column and then you won´t see any useless ID´s in that field
in form. Well now it´s up to you

Regards
Jörn


Am 06.06.2010 12:23, schrieb jase118 via AccessMonster.com:
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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:08 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.