Help with database

[Brucer]

Hello everyone I could use some help on a database I need to build. The way I am trying to build this would be like this



Last name
First name
Middle int
Address
State
Zip code
Date of birth
Age
Date year start
Date year end
Notes
Payments

The payments need to calculate every time I enter an amount to the same person

And I need the date of birth and date year start to calculate the person age, witch would tell me when a person would turn 52 or 63.

Thanks to anyone who can help me

[orange]

It isn't clear what the purpose of your intended data base is. There are sample data models (free) available online that may be helpful in your table set up.
See http://www.databaseanswers.org/data_models/index.htm

A quick comment on the fields you have identified.

If you have DoB, you don't need Age. You can calculate that at anytime.

Somewhere you are recording Payments against something. There is a missing Entity -- Loan, Mortgage???? What's the payment for?

Notes wouldn't normally be kept in the same table as name and address.
Could you have more than I note for a specific person? Would you want to know when the Note was made? Often Notes are a separate table, linked to the Person, and have a DateOfMessage type field to facilitate a "Notes history" for the person.

When you get to the actual database, get a naming convention that does not include spaces in Field names. It will save you a lot of grief as you proceed.

One technique to help with design is to make a list of all the "rules" that the database will adhere to/support. Here's a sample (totally out of context but meant to show the general concept)
http://www.databaseanswers.org/data_...ment/facts.htm

Good luck with your project.

[Brucer]

Hi Orange the date of birth needs to be calculated to show when a person turns a certain age so they can be taken of of a certain plan like a life insurance or dental plan. It would be like this. If you got on the plan in 1957 and the date you were put on the plan was 09/14/1957 would need to calculate when that person turned 53 or 63. Does that sound correct ? You are an expert and I appreciate your help

[orange]

Yes that sounds correct. I jumped ahead a little. Many times we see people include DOB and Age in a proposed table.
If you know when someone was born (DOB) you can calculate (DateDiff) from today's date and determine age. If you put a calculated value (Age) in a table, you don't really know when that Age was calculated---and you can't assume it's current. But doing a query based on Today's date and Dob you can get the value whenever you need it and it will be current.

Take a look at the links provided. I'm sure they'll help.