Help! Need to build a scheduling program with Access 2002

[Dano]

Can anyone recommend a way to set up an automated data entry program with
access? Need to schedule out students and tutors of a small school and
program needs to print out schedules and match tutors with students and their
profiles withinn two dbases. It's a hrad thing for me to explain, but
basically need to know how to setup print outs and also autonmated data entry
for reports on days time and courses, along with some personal demographics
of profiles in both dbases.

A stepping stone is greatly need here...Please comments and work with me
here, I will respond to questions as they come as to how the information
should be outputted...

Thanks!

 

[Fred]

Dear Dano,

You left out a lot of the key stuff about what exactly this is supposed to
do.

One student with one tutor at a time?
Are there resource liimitations / constraints. Like tutor availability?
Is the DB supposed to solve the jigsaw puzzle of creating the schedule?



It might end up as a structure like this being useful:

Table of students with a Primary Key like StudentIDNumber
Table of instructors with a PK like InstructorIDNumber


A table of instances of scheduling of a student with a tutor.

Might have the above ID# fields plus a schedule/time date field.

 

[Jeff Boyce]

Dano

Based only on your description, it sounds like you want to learn how to use
Access. Great! Just be aware that there are as many as three separate
learning curves involved...

First, if you don't understand "relational" and "normalized", brush up on
them. Access expects data stored this way.

Second, learning about and using the objects Access offers can take quite a
while. There are on-line tutorials and classes devoted to this. Some (of
us) have been at it for 15+ years now <g>!

Finally, if you want someone else to use what you build, you'll need to know
about and pay attention to graphical user interface considerations. For
example, some folks just starting out want to have a screen flash to catch
their users' attention. Uhmmm, did you know that folks susceptible to
epileptic seizures can have one when presented with flashing lights?!

If you aren't discouraged yet, congratulations! Keep coming back to these
newsgroups with specific questions and you'll probably get specific answers
from the many volunteers who hang out here.

Regards

Jeff Boyce
Microsoft Office/Access MVP