questions above ^

and this is what ive done bellow

and this is the infomarion about the topic bellow:

Using the data models and entity-relationship diagrams you designed earlier in the week in your group work, create an MS-Access database containing about 4 tables. You can have more if the scenario requires it, but keep it reasonable considering that this is a Fastrack exercise and you don't have an entire semester to finish it. In this database, design and create the following components: 1. Two queries that use columns from at least two related tables and have at least one customized column (formatting or calculation) 2. Two forms that allow data entry and modification, and have some customization (field layout/formatting, company logo image, custom background, etc.) 3. Two reports that display grouped data and have page numbering in the footer of each page, and have some customization (field layout/formatting, company logo image, custom background, etc.) 4. A navigation form to make the other objects accessible. The Calgary hotel offers various types of rooms. The hotel's system of taking reservations, specifically, over the phone bookings, requires gathering important details such as check-in and check-out dates, the number of people staying, and the guest's preferred type of room. To create the guest folio, personal information must be taken from the guest such as: first and last name of the person under the reservation, home address, phone number, and email address. To guarantee the room, it is the hotel's policy to secure credit card information to finalize the booking. John Smith is planning to have a vacation with his family so he booked a room in a hotel for 3 nights, a room type of 2 Queen size beds, and planning to check in in early October. He's coming with his wife and 2 kids. The room that he got is on the 4 th-floor room 404 (Sometimes could hardly be found) and his rate for each night is $120 and he'll be paying everything upon check out