Well, you are posting in a Access (database) forum, so there are some critical concepts with relational database that may apply. Each table contains information about a single subject. You may also research
Normalization
Suggests, there could be guests/occupants of a hotel room(s). Occupancy could be for 1 or many Days.
So you may be looking at tables for:
Guest/Customer
Room
RoomType
Occupancy/Booking
The facility has 1 or many Rooms
At any time 1 or more rooms may be occupied
At any time 1 or more rooms could be undergoing maintenance and be unavailable
At any time 1 or more rooms could be available for booking
1 or more guests could make a Booking
A booking is a rental for 1 or more rooms by 1 or more guests for a stated period of time
The facility's rooms may be of 1 or may types
.....
Draft data model from Barry Williams' site that may offer some insight.