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
|
|||
|
|||
MAJOR HELP!!!!!
hi there, i need major help for a new system i have to create. basically, my
new system is a school booking system that allows teachers to book out laptops, computer rooms, cameras, digital cameras and text books for the school day. i have no idea on what tables to have and how to set it out. each school day has 5 lessons and the teachers should be able to select a lesson and the day they want to book the items for and pre book what they want for the time they want it. i really need help as this is quite complex and there are no websites that will provide this information for me. any ideas on how i could do this? many thanks, -- xGemsiex |
#3
|
|||
|
|||
MAJOR HELP!!!!!
This forum is for free advice, not solicitations to sell.
Start with defining your mission even more clearly (to your self to to this forum) Including: What data it is your mission to record. Clarifying questions for your case would be: Reservations? (prior to them having it, and when they have it [due date}) Transactions? (They took it, they brought it back etc.) Current "borrowing" status (they have it or they don't) Current status of ALL equipment (borrowed, broke,ready to go, lost etc) What do you want your database do? (show certain things, print certain things, etc.) Then design a table structure that supports accomplishment of the above. If need help, provide the above info/clarifications and ask this forum. Sincerely, Fred |
#4
|
|||
|
|||
MAJOR HELP!!!!!
"Steve" wrote in message
news I provide help with Access applications for a modest fee. If you are willing to pay a reasonable fee for the "Major Help" you want, contact me at . Here are a couple of comments about my work ..... Steve These newsgroups are provided by Microsoft for FREE peer to peer support. Steve is a known troll whose only interest in these newsgroups is to con unsuspecting posters out of money by providing questionalbe services. He has proven many times in these newsgroups his lack of skill with Access and when questioned on his unethical behaviour his response is to threaten frivolous lawsuits. He is definitel, someone to avoid when looking for real help. John... Visio MVP |
#5
|
|||
|
|||
MAJOR HELP!!!!!
"Steve" wrote in message
news Here are a couple of comments about my work ..... "Has to ask in a public forum how to complete simple actions in a report design". More information he http://home.tiscali.nl/arracom/whoissteve.html |
#6
|
|||
|
|||
MAJOR HELP!!!!!
On 10 nov, 13:57, xGemsiex wrote:
hi there, i need major help for a new system i have to create. basically, my new system is a school booking system that allows teachers to book out laptops, computer rooms, cameras, digital cameras and text books for the school day. i have no idea on what tables to have and how to set it out. each school day has 5 lessons and the teachers should be able to select a lesson and the day they want to book the items for and pre book what they want for the time they want it. i really need help as this is quite complex and there are no websites that will provide this information for me. any ideas on how i could do this? many thanks, -- xGemsiex Hi xGemsiex, You didn't ask us to solve your assignment, but just for some input to get you going. You may start with three tables. Item, with a line for every camera, laptop, computer room etcetera. Teacher, used for anybody who may book items. Booking, which relates items to the teacher who booked them and the applicable lesson(s). Every Item requires a unique identifier, meaning you should provide stick-on labels. The unique code on each label wil be a primary key in table Items. You decide whether you want to put a label on each computer room, or use an alternative way of identifying them, like 'Computer Room 1'. Still, as a primary key you would still use what would otherwise be on the label identifying Computer Room 1. Teachers likewise need a unique identifier, but you cannot really go about pinning labels to their jackets. Same principle applies as to 'Computer Room 1' above. Booking contains a reference to Teacher, so you know which teacher the booking belongs to. It should also contain a reference to Item which tells you the booked item(s). Additionally, Booking should contain the period (day, lesson) a booking applies to. The way I go about designing tables is quite simple. First put all similar things in their own table (items and teachers). Second decide how they are related. A useful way of finding such relationships is making sentences like 'Teachers book Items for a certain Lesson'. You already knew that your system is about 'booking', which provides the verb. Just don't forget that a booking applies to a certain period. Hope this helps. |
#7
|
|||
|
|||
MAJOR HELP!!!!!
On Mon, 10 Nov 2008 04:57:01 -0800, xGemsiex
wrote: hi there, i need major help for a new system i have to create. basically, my new system is a school booking system that allows teachers to book out laptops, computer rooms, cameras, digital cameras and text books for the school day. i have no idea on what tables to have and how to set it out. each school day has 5 lessons and the teachers should be able to select a lesson and the day they want to book the items for and pre book what they want for the time they want it. i really need help as this is quite complex and there are no websites that will provide this information for me. any ideas on how i could do this? many thanks, There are in fact lots of resources available on the web, and some good books on how to develop Access systems. Here are some references with leads to many mo Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html A free tutorial written by Crystal (MS Access MVP): http://allenbrowne.com/casu-22.html MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|