Results 1 to 4 of 4
  1. #1
    IsiEMT is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    2

    School bus transportation


    As a tech savvy, I was asked to find a program for our school bus transportation. The goal is that every bus driver should get a daily printout with all changes of stops. Top portion will be kids from other buses coming for a bus change to this bus, and bottom portion for kids normally on this bus, but have a change to another bus. Like that the driver will know where to stop or not to stop.

    It should work with calendar, so some changes are only for a day, others might be several. On each daily printout the relevant and active changes should be printed. Sure enough for each driver separately.

    Basically it should be more or less automated. The user should be able to just select the day, and only drivers who have any change would show up on the report. Each bus driver also has a bus "color". This color can vary depending on which trip. So when choosing a driver and which trip, the color should be shown automatically.

    I'm not sure how to do that. I first thought maybe there's a website for similar things. Maybe Google Calendar. But I saw there are several features lacking in Google Calendar. Maybe a standalone program? Maybe a program that integrates with an online service? Maybe employee scheduling? Maybe Microsoft Excel or Access?

    I'm not sure if this is the right place to get this help, but right now I have nowhere else to turn. Any guidance will be greatly appreciated!

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    This is a good scenario for creating an Access database. However, you are asking us to design the database for you and this is asking too much from this forum.

    I can offer my services, however!

  3. #3
    IsiEMT is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    2
    Hi aytee111,

    Not sure if you got my previous PM. You offered your services, and I'd like to hear more details. Please get back to me. Thanks!

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

Please reply to this thread with any new information or opinions.

Similar Threads

  1. School Enrollment Database
    By jpepin in forum Database Design
    Replies: 1
    Last Post: 04-08-2010, 05:23 PM
  2. Need help a school report database
    By learnac in forum Database Design
    Replies: 1
    Last Post: 01-28-2010, 09:14 PM
  3. High School Help
    By mfgriggs in forum Queries
    Replies: 3
    Last Post: 11-18-2009, 01:18 PM
  4. Database Design for a School
    By FallingToaster in forum Database Design
    Replies: 2
    Last Post: 08-12-2009, 10:47 PM
  5. Querying Queries for Music School
    By jenny_jumps in forum Queries
    Replies: 0
    Last Post: 01-28-2009, 11:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums