Simple Holiday bookings database?

[darkan99el]

Hi all, would like a few pointers and a bit of help please. I want to make a basic database to hold simple booking information for two holiday homes, with forms for easy input of the data. The details I need are Customer details i.e. name address phone number etc, credit card details, and a booking details, i.e. which holiday home, from and to dates how many adults, deposit paid and balance if any, I also need the balance to be flagged for payment 6 weeks prior to actually from date. I understand I need to make primary keys and be able to link them; make a relationship, but I'm not sure if I'm making things too complicated. I've made some tables with fields and allocated data types to them; hopefully the correct ones lol! I have a Customer table, a Bookings table and a Credit card table, each table has a primary key i.e. Customer ID, Card ID and Bookings ID I'm a bit stuck at this point on how to link them all together, or whether i can even simplify it somehow. i.e can I have all this info in one table or am I going right by splitting this info up and if so have I split it correctly? Also how do I get access to each table from a form? I am a total novice at Access, so be gentle lol! Thank you for your time

[orange]

Here's one of several data models that may be useful

http://www.databaseanswers.org/data_...omes/index.htm

Here's a link to Access guide
http://www.allenbrowne.com/casu-22.html

[darkan99el]

Thank you orange