We help IT Professionals succeed at work.
Get Started

Microsoft Access: Creating a payment system.

9,844 Views
Last Modified: 2013-11-29
Hello,

I am creating a database for a sports club and our members can pay in the following ways:

1. Per visit.
2. For one month.
3. 3 month contract.
4. 6 months contract.
5. 12 months contract.

What I need to achieve:

1. To be able to see what contract a client is using.
2. To see if they have payed for the latest month or if the are in debt for 1+ months.
3. How many months are left to go on their contract.
4. Input monthly payments (Date, type (cash, credit card, direct debit etc.))
5. See if they have an active contract or if it has finished already.

So far I've got tables for:

Clients. (Client information)
Clubs. (Data for the 2 clubs that we have right now)
Contracts. (Type of contract, start date, end date, fee, active or not)
Payment. (Payment Date, Payment Fee, Payment Type)
Purchase type. (1 time card, 1 month card, 3 months contract, 6months contract. etc.)

Now then, I am not sure if this design is ok, and how should I tie this together in order for the system to work properly?

Best Regards,

NewSkol
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE