Need any hint or help with organization

[Jessica]

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.

 

[Jeff Boyce]

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

 

[redant]

ok i could not find. Let me see...

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.

 

[m stroup]

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.

 

[redant]

Thank you. I will look this over. I have so much to do. Thanks!

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.

 

[redant via AccessMonster.com]

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!

Sounds like a complex,

[quoted text clipped - 23 lines]

 

[redant via AccessMonster.com]

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
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]

 

[redant via AccessMonster.com]

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!!!

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]

 

[redant via AccessMonster.com]

So is it a One to Many relationship I need?

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]