Trouble with generating specific reports (1 Viewer)

Hi i am new to Access and databases in general. My problem is, i am using SQL server 2008 and Access together and i have created all the tables for a fake hotel booking system, i'm not sure if its a fairly simple problem or whether my tables are designed wrong i just can't seem to get my head round it. The problem is i need to generate 2 reports for this:-
1) A report which shows how much income each room type generates
2)A report which shows available rooms on a specified date.
Attached are my tables and relationships between them. Any help at all would be greatly appreciated. Kieran