MAJOR HELP!!!!!

[xGemsiex]

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,

 

[Fred]

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

 

[John... Visio MVP]

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 (e-mail address removed). 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

 

[Keith Wilby]

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 here:

http://home.tiscali.nl/arracom/whoissteve.html

 

[floronDBA]

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,

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.

 

[John W. Vinson]

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
more:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/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