but depending on what information is going to be collated, i.e. whether it refers to just the rooms, or to customers as well, they may need to be aware of the details of the data protection act.
I don't mean this to be scarmongering.. just pointing out something to consider.
Also, something else to consider... when I was at college a couple of years ago, though it wasn't a course I did, I was aware of others doing computing courses who had to develop something using Access. They were strongly encouraged to get a "real world" problem to develop. This sounds like just the sort of thing. Perhaps your friend could approach a local college and see if it's something someone there would like to get their teeth into?