Help with creating organizing database for first time

[Jessica]

I have a small project to do and if anyone can help in any way I'd appreciate
it.

I have a group of courses that need to be put in the database. Each may have
one of the following:

Title, Description, Type, Sub-Type, Quarter, Audience(s), Objectives,
Prerequisites, Length, Date(s), Location(s), Resource(s)

There can be more than one "date" and "location" per class. There may be
"resources" to be downloaded. There is an
"audience" category which is like who will take the class e.g, engineer,
shop hand, manager etc. There are approximately 9 "types" of courses within
those types there are sub-types. The classes are listed under the sub-types.

Some of the courses may be under more than one type and sub-type

Any hints help are appreciated.

 

[Jeff Boyce]

Jessica

These are some fairly specific constraints and requirements. Is this
homework?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

What is the purpose of the database? What is it suppose to produce?

 

[tina]

recommend you read up on relational design principles, so you can structure
your tables/relationships correctly. with the proper design implemented, the
rest will flow much more smoothly and easily. for more information, see
http://home.att.net/~california.db/tips.html#aTip1.

hth