Search results

I know there are a lot of previous threads about double booking, but I'm really not sure how to carry this one out. Currently, my database is a B&B. In the B&B, there are 3 types of each room (3 Standard, 3 Double and 3 Deluxe). I want to have a check availability button, so I can check if the...

Hello! I need a bit of help, I'm making a database based on a beautician's spa. Basically, I want to use VBA (or queries, if necessary) to check that an appointment isn't already confirmed for a particular appointment. At the minute, I have a query which contains: Date of appointment (Format...

Hi. My ICT coursework requires this database to be normalised to 3NF, and I was wondering if you could check if it works? To me it makes sense, but I don't think that's a great way to confirm it!:p In short: *One customer can have many credit cards attributed to them. *One customer can create...

Firstly, I'd like to say this is my ICT coursework, and I'm unfortunately pretty inexperienced with Access. I can use VBA to an extent, but I really need help! I've created a database based on a beautician's spa. Basically, I think there may be a problem with the relationships in the database...