Need to create a database for booking rooms in a house

[SkillipEvolver]

Hi all,

wondering if anyone can help,
I need to create a system to book students into available rooms in a variety of houses

the number of rooms in each house varies, some have 1 bed, some have 2, some have double bed

I've created a table in access of:
* the house address and postcode
*The owners name

But I need to create a table with other data in it (ROOM INFORMATION) (the number of rooms, and how many beds are in each room)

How do I create this in access so that when I pick an addess from a dropdown list of addresses, I can see the related data from that other table (ROOM INFORMATION) ?

I am thinking I need to make a link between the two tables, but I don't understand how?



After that I am wanting to create the forms for that ROOM INFORMATION table so that users can pick/fill in the data (ie number of rooms, number of beds etc)

I'm desparate. I am having a really stressful day, if anyone is able to help quickly, I would really appreciate it
Thanks!

[ranman256]

The tRooms table would have :
RoomID (autoNum)
HouseID (from tHouse table)
RenterID (from tRenter table, null if empty)
RoomNum
Size
beds
baths
RentAmt


TRentDate table:
RoomID
RenterID
StartDate
EndDate
RentAmt
etc...

[SkillipEvolver]

Im really struggling today, I have a massive anxiety problem at the moment and it's stopping me from understanding things.
I've tried to understand what you've written but im struggling.

My job depends on my ability to do this, I definitely need to understand acccess more but Im in a tight spot.

If I was able to send you the accdb file, maybe it would be easier for you to see what im trying to do?
I'm not worried about setting up the renting process yet, i will try to do that later

For now i just need to try and create a link between the ROOM INFO table and the ADDRESS table so that when I make a form,
I can flick through a list of addresses from a drop down and see the statistics (how many rooms, how many beds) they contain.

In my file, the table 'Hostfamily Data Base' contains the ADDRESS info (it also contains information i need to split up into other tables)


Do you think you could have a look at it for me?
I am not against learning at all but I am in a very very desperate spot, plus I have anxiety like mad and just found out someone in my family is very ill too. :-( I would be sooo greatful


I've uploaded the file here:
https://drive.google.com/open?id=1uG-o3E2_K0XnjpMJv3mKrGvcLVvDPH6J
https://drive.google.com/open?id=1uG...mKrGvcLVvDPH6J

[SkillipEvolver]

Is anyone else able to help? Im really stuck

[orange]

Hmmm??

If I was able to send you the accdb file, maybe it would be easier for you to see what im trying to do?
I'm not worried about setting up the renting process yet, i will try to do that later

It is not easier for anyone to look at a physical table(s) and understand WHAT you are trying to do. Now, there are some excellent guessers on the forum --some may even border on clairvoyant--but guessing what someone else's business is from what was intended by viewing physical database tables is an extremely poor and inefficient strategy.

Write a simple description (30,000 ft level) of WHAT you are attempting to support with a database. Keep it in simple English.
A physical database or table(s) is one of many possible ways of HOW that business support could be implemented.

Ranman has identified some possible tables and attributes that should help.

House, Rooms, Location, Rent, Renter, Availability, rentalContract, RentalConditions
I also see
a House has 1 or many Owners
an Owner has 1 or many communication coordinate(s) (email, phone, cellphone...)
a House contains 1 or many Rooms
a House has a Physical Address(street no,apt no, street, city,postal code...)
a Room has attributes (sqft,beds, bath, TV, internet.....)
a Room has a suggested Rent/period
a Room may be associated with a rentalContract
a rentalContract has 1 or many conditions

These are offered for consideration/discussion to help you formulate a model of What the business you are attempting to support with your proposed database. Many may be disposed of immediately; some may be within the scope of your project. You know the details; we don't. We only know what you tell us and that has been sparse.

I hope this is helpful.
Good luck with your project.

See the link in my signature re Database Planning and Design for additional info.

Cross posted at https://access-programmers.co.uk/for...d.php?t=303642

[isladogs]

Skillip
Your previous thread was cross posted on 3 different forums.
I provided a link to explain why it matters and gave links to the threads on each forum.
You didn't even acknowledge the point being made.
You've now done the same again, Cross posting at Access World Forums with no link provided. If you do cross post, be upfront about it and please provide the links at each site yourself
I will copy this to the other forum but leave you to do the links

[SkillipEvolver]

This is clearly quite a big project with a lot to consider but I just want to start basic.
I appreciate the feedback, I'm sorry for my flippant nature.

The overall goal is to have a system where staff can choose a student, and book them in to a room in a house.
I need to create a calendar style layout (typical 28day/month) on screen where staff can :

1) Choose a house from a dropdown
2) choose a student from a drop down, and select that student to add them to a calendar for that particular house (quite often they are staying for 7 days at a time).

We have certain considerations to make (our judgement) about who should stay where, depending on their age, their preference about pets in the house, things like that.
But I would like to think those are bridges I can cross later on.

I just want to be able to create a system at first which can record who is staying where at which dates.

So I feel that I need a system which, when I select a house address, can show how:
* The number of rooms in the house
* The number of beds in each room (there can be more than 1)
* Whether that bed is available at the moment


There are lots of other things I'll need to work in eventually, to match compatibility of student to house (like preference to pets or not), whether the house provider offers vegetarian food,
but for now I just want to be able to show information about availability.
So far I have a table with :
* address
* house owner
* tel number

And another with student info in it:
* Student name
* DOB

This is a complicated project I know it, but Im just trying to start with that basic principle of being able to book someone into a space.

I've searched google for a hotel management / booking access template but I cant find much out there of use and one of them in particular had lots of VBA knowledge required.