|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 10th, 2009, 06:44 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Need any hint or help with organization
I have never created a database before and this first one is not simple. ANy
help would be appreciated. This is a database of training courses Title, Description, Type, Sub-Type, Quarter, Audience(s), Objectives, Prerequisites, Length, Date(s), Location(s), Resource(s) CourseID Title Description Type Sub-Type Audience Type Prerequisites Length/Days ClassID CourseID Quarter Date Location Resource The class can be on more than one day at more than one location and have more than one resource (downloadable pdf files) The course can have more than one Audience Type I'm really confused any help would be appreciated. 
|
|
#2
February 10th, 2009, 07:35 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
This sounds much like an earlier post by someone going as "Jessica". Have
you looked at the suggestions offered to that post? Regards Jeff Boyce Microsoft Office/Access MVP "Jessica" u49508@uwe wrote in message news:91829bfa8a753@uwe... I have never created a database before and this first one is not simple. ANy help would be appreciated. This is a database of training courses Title, Description, Type, Sub-Type, Quarter, Audience(s), Objectives, Prerequisites, Length, Date(s), Location(s), Resource(s) CourseID Title Description Type Sub-Type Audience Type Prerequisites Length/Days ClassID CourseID Quarter Date Location Resource The class can be on more than one day at more than one location and have more than one resource (downloadable pdf files) The course can have more than one Audience Type I'm really confused any help would be appreciated.
|
|
#3
February 10th, 2009, 07:59 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
ok i could not find. Let me see...
Jeff Boyce wrote: This sounds much like an earlier post by someone going as "Jessica". Have you looked at the suggestions offered to that post? Regards Jeff Boyce Microsoft Office/Access MVP I have never created a database before and this first one is not simple. ANy [quoted text clipped - 28 lines] I'm really confused any help would be appreciated.
|
|
#4
February 10th, 2009, 10:02 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
Sounds like a complex,
"tblCourses" CourseID(PK)/Title/Description/Type/Sub-Type/Length_Days "tblClasses" ClassID(PK)/CourseID(FK)/Quarter/Date/Location "tblXOverAudiences" AudienceXOverID(PK)/CourseID(FK from tblCourses)/AudienceType (could be FK from tblAudienceTypes) "tblXoverPrereqs" PreReqXOverID(PK)/CourseID(FK from tblCourses)/PreReq (could be FK from tblPreReqs or even from tblCourses) "tblXoverResources" ResourceXOverID(PK)/ClassID(FK from tblClasses)/Resource (could be FK from tblResources) This might help get you started. -- Teach me to fish! Thanks for the help. Pax, M "Jessica" wrote: I have never created a database before and this first one is not simple. ANy help would be appreciated. This is a database of training courses Title, Description, Type, Sub-Type, Quarter, Audience(s), Objectives, Prerequisites, Length, Date(s), Location(s), Resource(s) CourseID Title Description Type Sub-Type Audience Type Prerequisites Length/Days ClassID CourseID Quarter Date Location Resource The class can be on more than one day at more than one location and have more than one resource (downloadable pdf files) The course can have more than one Audience Type I'm really confused any help would be appreciated.
|
|
#5
February 10th, 2009, 10:40 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
Thank you. I will look this over. I have so much to do. Thanks!
m stroup wrote: Sounds like a complex, "tblCourses" CourseID(PK)/Title/Description/Type/Sub-Type/Length_Days "tblClasses" ClassID(PK)/CourseID(FK)/Quarter/Date/Location "tblXOverAudiences" AudienceXOverID(PK)/CourseID(FK from tblCourses)/AudienceType (could be FK from tblAudienceTypes) "tblXoverPrereqs" PreReqXOverID(PK)/CourseID(FK from tblCourses)/PreReq (could be FK from tblPreReqs or even from tblCourses) "tblXoverResources" ResourceXOverID(PK)/ClassID(FK from tblClasses)/Resource (could be FK from tblResources) This might help get you started. I have never created a database before and this first one is not simple. ANy help would be appreciated. [quoted text clipped - 26 lines] I'm really confused any help would be appreciated.
|
|
#6
February 11th, 2009, 08:19 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
The current website I am recreating has a database which I do not have access
to. A template and cms was used. The user/manager input all of the data, in this case courses. How is this different than building a relational database yourself?? Any help is appreciated. redant wrote: Thank you. I will look this over. I have so much to do. Thanks! Sounds like a complex, [quoted text clipped - 23 lines] I'm really confused any help would be appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200902/1
|
|
#7
February 11th, 2009, 09:50 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
Disregard last post!!!
redant wrote: The current website I am recreating has a database which I do not have access to. A template and cms was used. The user/manager input all of the data, in this case courses. How is this different than building a relational database yourself?? Any help is appreciated. Thank you. I will look this over. I have so much to do. Thanks! [quoted text clipped - 3 lines] I'm really confused any help would be appreciated. -- Message posted via http://www.accessmonster.com
|
|
#8
February 12th, 2009, 04:16 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
I am still confused. I don't know if I am looking at it the wrong way.
I have training courses. That can be arranged in so many ways. Most courses belong to one type and subtype e.g., Type: Sales SubType: Field Sales But some basic training courses can be of Type: Sales, General, Engineering and then multiple Subtypes. The Subtypes are categories under the Types. Each course can have one or more Audiences e.g., Engineers, Sales, Shop Hand etc. meaning that the course pertains to the particular audience. Each course can have multiple dates and at various locations Dallas 09/08/09 Bellvue 10/10/09 Dubai 09/10/09 Each course may have multiple resources (pdf files) Each course has one Title, Description, Prerequisite and Length I'm trying to create a one to one table is it even doable? Course1Type1Subtype1a Course1Type5Subtype5b Course1Type6SubType6b Course1Type6SubType6a Course1Audience1 Course1Audience4 Course1Audience8 Course1Resource1 Course1Resource2 Course1Resource3 Course1Resource4 Course1 Date1Location1 Course1Date2Location2 CourseDate3Location3 I apologize for being such a newbie. I am able to connect to the data fine and display data dynamically it's just thte organization of the database. I want to do it right. Any thoughts help is appreciated. redant wrote: Disregard last post!!! The current website I am recreating has a database which I do not have access to. A template and cms was used. The user/manager input all of the data, in [quoted text clipped - 6 lines] I'm really confused any help would be appreciated. -- Message posted via http://www.accessmonster.com
|
|
#9
February 12th, 2009, 04:19 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Need any hint or help with organization
So is it a One to Many relationship I need?
redant wrote: I am still confused. I don't know if I am looking at it the wrong way. I have training courses. That can be arranged in so many ways. Most courses belong to one type and subtype e.g., Type: Sales SubType: Field Sales But some basic training courses can be of Type: Sales, General, Engineering and then multiple Subtypes. The Subtypes are categories under the Types. Each course can have one or more Audiences e.g., Engineers, Sales, Shop Hand etc. meaning that the course pertains to the particular audience. Each course can have multiple dates and at various locations Dallas 09/08/09 Bellvue 10/10/09 Dubai 09/10/09 Each course may have multiple resources (pdf files) Each course has one Title, Description, Prerequisite and Length I'm trying to create a one to one table is it even doable? Course1Type1Subtype1a Course1Type5Subtype5b Course1Type6SubType6b Course1Type6SubType6a Course1Audience1 Course1Audience4 Course1Audience8 Course1Resource1 Course1Resource2 Course1Resource3 Course1Resource4 Course1 Date1Location1 Course1Date2Location2 CourseDate3Location3 I apologize for being such a newbie. I am able to connect to the data fine and display data dynamically it's just thte organization of the database. I want to do it right. Any thoughts help is appreciated. Disregard last post!!! [quoted text clipped - 3 lines] I'm really confused any help would be appreciated. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/200902/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
