Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database Design - change (97/SR2)

    I have an existing database that has been working great for years. Now, they want to change it. In the past, we taught classes that would last only a day. We were not concerned with an ending date or time. We are now offering classes that last over 2 weeks, only 2 days a week (every tues/thurs for 2 weeks). I need to modified my table to accept these changes as well as my reports. I have a report that print scheduled classes and any materials requested. It works great for a day but how can I tell it the room is booked for 4 days without entering every day the class if offered. I need the program to schedule the class and register the students once but show the information for the 4 days the class if offered. I hope this makes sense.

    I need some help or some guidance on looking into a scheduler/room reservation/student record/course entry program.

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Design - change (97/SR2)

    Deborah

    For the price of a book you may find what your looking for here in Registration Management

    HTH, John

    http://www.viescas.com/Info/books.htm#Access

    You can find lots of Access books that give you neat tips and tricks to make your applications more robust, but none that give you a complete application with all the features built-in and a thorough guide to how the application works. Building Microsoft Access Applications includes four, count 'em four, complete and working applications, and the chapters walk you through the table design and all the code that makes the applications work. The applications included in the book and on the CD are Membership Tracking, Inventory Management, Customer Support, and Registration Management. This was a fun set of applications to build, and it's a testimony to the power of Access that I built all four in less than a year.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Design - change (97/SR2)

    I went to the book store today to check out the book. I flipped through the chapter on registration management and saw a lot of similar features that I have in my database. I was on the way to the checkout when I decided I better check the version. We still have 97 and the database will not open in 97. I had 2003 on my computer at home but lost it to a lighting strike a week ago.

    Thanks for the information. I will be buying the book as soon as I can get something to open the files.

    One question: I am going to ask the user if I can create a day/time field (T,TH 5:30-8:30) instead of creating the class session every time the class is taught. If I had a student come in on the 2nd night, I guess I would have to add their name to the first night and then reprint the roster. I really would not want to give them credit for the entire class. Still thinking...

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Database Design - change (97/SR2)

    I think you will need another table. If you have a tblClass now, this would be tblClassMeetings. It would contain 1 entry for each class meeting, so if a class meets only once, it will have 1 entry, but if it meets 4 times it will have 4 entries. Each entry should have meetingdate, classTimeBegin, ClassTimeEnd, and place. This method gives you the most flexibility, as you don't know what situations might come up later. It may seem like extra trouble, but your data entry form for creating new classes can include a button to autocreate the class meetings.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •