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
|
|||
|
|||
Help! Need to build a scheduling program with Access 2002
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! |
#2
|
|||
|
|||
Help! Need to build a scheduling program with Access 2002
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. "Dano" wrote: 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! |
#3
|
|||
|
|||
Help! Need to build a scheduling program with Access 2002
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 "Dano" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|