HELP MICROSOFT ACCESS!.?

You need to use code for this if you want to get a meaningful result. As it is you need a multi field key to check that your attempted entry can not be added. Impossible with 2 date fields. You would need to run multiple queries otherwise to check that a room was vacant on the dates required. You can not do this without code.