Re: Microsoft Access
Hi Karl, I am currently trying to create a database for a fee for storage company that specialises in caravans, campers trailers, boats, cars and shipping containers. Locked undercover storage for an increased fee is also available. the business for the most part runs on prompt pre-paid/in advance storage. some laggards exist.
I have set up three tables so far:
1 - asset details of what is stored - make model color length undercover etc
2 - customer details - phone, address, name, email etc
3 - payment/receipts - name, amount,date paid,date paid from, date paid to and receipt number