HELP ME PLEASE

[JaySaN]

We want to create a database for campers at a youth camp this year. We want
to add their names to the database, and have the database assign them rooms,
based on Gender and capacity. Is there a way someone can show me how to do
this?

please it is urgent

 

[Jeff Boyce]

Before you try to build this yourself, have you checked on-line to see if
there are any templates that might already be able to do this?

How much experience do you have building applications? Understanding
"normalization" and "relational"? Using MS Access?

Those are three separate learning curves you can plan on facing.

If your need is truly urgent, you might end up hiring someone to build this
if your answers above are "limited" and if you don't find something already
built that will work for you.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Steve]

Consider starting with the tables:

TblCamper
CamperID
CamperFirstName
CamperLastName
DateOfBirth
Gender
<Other fields relative to a camper>

TblRoom
RoomID
RoomNumber
RoomCapacity

TblRoomReservation
RoomReservationID
RoomID
CamperID
BeginDate
EndDate

I provide help with Access, Excel and Word applications for a very
reasonable fee. I could build this application for you for a small fee. If
interested, contact me at (e-mail address removed).

Steve

 

[John... Visio MVP]

I provide help with Access, Excel and Word applications for a very
reasonable fee. I could build this application for you for a small fee. If
interested, contact me at (e-mail address removed).

Steve

No you don't! You just hang around here trying to con people out of money.

These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is too thick to understand this even though he has been told many
times over the past years.

Currently he is using Roberta Laird has his alias. Stevie, your MIL must be
proud of your sleazy behaviour.

John... Visio MVP