Course schedule

[Guest]

Hi,

I am a beginner in MS Access. I got the following problem.
I've made an course database and I would like to make a schedule in it.
The following items are known:
1. number of total lessons (differend per course)
2. number of lessons a week (differend per course)
3. the weekdays a couse is given (p.e. wednesday and saturday)

Question:
With the startdate of the course known I would like to automaticly create a
schedule for the course so the output should smething like:

Lesson 1 wednesday 1/3/2007 19:00-20:00
Lesson 2 saturday 1/6/2007 10:00-11:00
Lesson 3 wednesday 1/10/2007 19:00-20:00
Lesson 4 saturday 1/13/2007 10:00-11:00

Is this possible in MS Access and so, how can I do this ??

Thanks in advance for help,

Greetings,
JacobK.

 

[Larry Linson]

If you have the data, and can define the requirements for when to schedule,
the answer is, yes, you can create the schedule in Access. How you would do
so will depend on the data you have, how you have the data stored, and in
what form you want the output (e.g., what use will you make of the schedule,
once you have it).

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks for your reply Larry.
The output should be on a report, but it also will be nice on a form too.
I'll have the following tables:
tblCourse
-id
-coursename
-total lessons
-lessons a week

tblCourseGroups
-id
-groupname
-course_id
-startdate
-enddate

tblCourseWeekdays
-id
-course_id
-weekday
-starttime
-endtime

One course have more groups through the year, p.e. group1 in january, group2
in februari and so on.
A course can be scheduled 1 time a week, 2 times a week and so on.

I'm almost done with a Sub in VBA, but this works only with one weekday.
The functions I use are DateAdd in combination with Weekday.
I'll just need the solution for a formula that works on a schedule 1,2 and
more times a week.

Perhaps I'm asking to much, but it gets me on to solve this problem...

 

[Larry Linson]

You say "a course can be scheduled once a week or more times a week" -- is
each "instance" of the course considered a "course group" (a separate record
in tblCourseGroups)?

When you say "A course can be scheduled 1 time a week, 2 times a week and so
on." that could mean that you could have multiple sessions of a Course, or
of a CourseGroup (depending on the definition) going on concurrently, or
simply that an instance of a course could meet only once a week or it could
meet two or more times each week.

Is all the Course Weekday information entered manually? (Or are you trying
to automate the assigning of times? If the latter, you will complicate your
development.)

If a CourseGroup is to meet on Mondays and Wednesdays, do you just have the
two Records in tblCourseWeekdays, or do you have one record for each class
meeting date?

I'm asking you quite a few questions, hoping they will trigger you thinking
about the subjects and issues I raise. Basically, what you do is consider
how you would perform the task manually, and decide what you'll need to do
to automate that process, and which parts of it can be automated. A database
[often | usually | always] models the real world, in just enough detail to
accomplish the required task.

A newsgroup is not a venue where one can go through the complete
requirements, design, and implementation of a database application -- nor is
that the purpose of newsgroups. So, don't let my questions mislead you into
thinking that we are launching a "project via newsgroup".

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry,

First I wish you and all the people on this forum the best wishes and
happyness in 2007 !!

Thanks for your reply.
I'll think about the development as you suggested.
Sure I understand, that this forum is not ment to be to discuss a complete
application development.
I'll think the basics are good.
I'll find out wich formula I'll need to get the job done.

Thanks anyway.

Greetz,
jacobK.

You say "a course can be scheduled once a week or more times a week" -- is
each "instance" of the course considered a "course group" (a separate record
in tblCourseGroups)?

When you say "A course can be scheduled 1 time a week, 2 times a week and so
on." that could mean that you could have multiple sessions of a Course, or
of a CourseGroup (depending on the definition) going on concurrently, or
simply that an instance of a course could meet only once a week or it could
meet two or more times each week.

Is all the Course Weekday information entered manually? (Or are you trying
to automate the assigning of times? If the latter, you will complicate your
development.)

If a CourseGroup is to meet on Mondays and Wednesdays, do you just have the
two Records in tblCourseWeekdays, or do you have one record for each class
meeting date?

I'm asking you quite a few questions, hoping they will trigger you thinking
about the subjects and issues I raise. Basically, what you do is consider
how you would perform the task manually, and decide what you'll need to do
to automate that process, and which parts of it can be automated. A database
[often | usually | always] models the real world, in just enough detail to
accomplish the required task.

A newsgroup is not a venue where one can go through the complete
requirements, design, and implementation of a database application -- nor is
that the purpose of newsgroups. So, don't let my questions mislead you into
thinking that we are launching a "project via newsgroup".

Larry Linson
Microsoft Access MVP

Thanks for your reply Larry.
The output should be on a report, but it also will be nice on a form too.
I'll have the following tables:
tblCourse
-id
-coursename
-total lessons
-lessons a week

tblCourseGroups
-id
-groupname
-course_id
-startdate
-enddate

tblCourseWeekdays
-id
-course_id
-weekday
-starttime
-endtime

One course have more groups through the year, p.e. group1 in january,
group2
in februari and so on.
A course can be scheduled 1 time a week, 2 times a week and so on.

I'm almost done with a Sub in VBA, but this works only with one weekday.
The functions I use are DateAdd in combination with Weekday.
I'll just need the solution for a formula that works on a schedule 1,2 and
more times a week.

Perhaps I'm asking to much, but it gets me on to solve this problem...