Database Design – change (97/SR2)

Topic

New Reply

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.

Reply | Quote

Replies

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%5B/url%5D

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.

Reply | Quote

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…

Reply | Quote

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.

Reply | Quote