Am I on the right track?

[hamzack]

Hi! I am new to Access and am trying to create a database for my customers that tells me what product/service they avail of and the status of their payments.

My tables are

Customer Info
CustomerID
LastName
FirstName
Address
ContactNo

Products (A,B,C) ( A customer can only purchase one product)
CustomerID
ProductID


PaymentSchedule (Annual, Quarterly, Monthly)
CustomerID
PaymentSchedule

Annual Product Fees
Product
Fee

Quarterly Product Fees
Product
TotalFee
QuarterlyFee

Monthly Product Fees
Product
TotalFee
Downpayment
MonthlyFee

Am I doing ok so far? I wasn't sure How to make my tables since the amount payable is dependent on both the product type and the payment schedule. Any suggestions?

 

[atisz]

Maybe this will help you

I found this site a few month ago. If you're a biginner, i think you will find it usefull. It explains everithing. See this exemple: http://www.functionx.com/access/applications/convstore.htm

Attila

 

[hamzack]

Thanks, but...

The link you gave was helpful in so many ways. However, the format of the sample database is a little different from mine as I have to deal with set modes of payment that entail different amounts per payment schedule.

For example, to purchase product A, a customer has three options available
Annual - one time payment of, say 120 bucks
Quartery - 4 equal payments of 35 bucks
Monthly - a downpayment of 50 plus 11 payments of 10 bucks

Naturally the values for product B and C differ as well.
And, since there is a schedule involved, I would have to find a way to know whether they are behind or on time with their payments.

 

[neileg]

You don't have a ProductInfo table. All of the fields called Product should be the productID from your ProductInfo table.

If customers can only purchase one product, your Products table is redundant, you can store the productID in your CustomerInfo table.

If your quarterlt or monthly payments can be calculated from the annual fee, you don't need these fields. You cqan calculate the values when you need them in a query or a form.