Reservation system room price changes according to date, occupancy, time and duration

[relvin]

Hi,
I have been using MS Access for some tasks and it is very handy. Due to increase efficiency on my new job I also want to create a database. But I am a little bit confused, because there are too many factors to consider. I hope you can help me by giving some ideas. So here is the situation.
I am supposed to give information to the customers according to their needs, while talking via phone.
I want to enter check-in and check-out dates and tell them prices on different premises. But prices vary according to:
1) Premises
2)Room type
3) whether staying one or two people on the room-single or double( because prices are full board)
4) Prices changes due to month of the year, and let say if someone check-in time is 29th of December and check-out time is 03rd of January. 2 days should be calculated on December's price and 2 days on January's price.
5) Prices are different also if someone stays up to 7 days, 7-13 days, 14-20 days and so on.
6) and also there are discounts sometimes(not always) premises offer like if someone stays 7 days, 1 night is free so he/she pays for 6 days.
On premises some room premises has same type of room while others may have different, I am planning to handle this via junction table. But for other issues I am really having hard time to configure.
So I hope you may give me some ideas.
Thanks in advance for your contribution

[June7]

Cross post https://www.access-programmers.co.uk...pation.325897/

Reservation management is a very complicated type of db system. Throwing in pricing just compounds the difficulty. Development will take a lot of time and effort. Has been topic of numereous discussions. Look at some of the links at bottom of this thread. Should probably do cost comparison with purchasing a system.

[Welshgasman]

Crossposted https://www.access-programmers.co.uk...pation.325897/

[relvin]

@Welshgasman and @June7 sorry for crossposting. This will not be repeated

[Micron]

Cross posting is allowed. It's when OP does not declare and provide a link that upsets others. Perhaps this will help explain

https://excelguru.ca/a-message-to-forum-cross-posters/

[orange]

See the Database Planning and Design link in my signature for a variety of articles and tutorials.
Google and youtube are good resources also.
You might want to spend some time on "data model" and "business rules" oriented materials. Get your tables and relationships vetted before dealing with forms and code.
This link on "stump the model" may be useful.
Good luck.