General discussion

Locked

Banking Database

By pr.garza ·
I want to create an Access database where customers can open as many bank accounts with different amounts for each account. (Ex: checking acct. w/$100; savings acct. w/$2,000; CD w/$10,000). The database has basic info such as cust. name; signer info; beneficiary info; (names, date of birth, Driver's License #'s). How do I go about creating the tables to show that one customer can open many accounts with different amounts?

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Banking Database

by pr.garza In reply to Banking Database

Point value changed by question poster.

Collapse -

Banking Database

by vgr2 In reply to Banking Database

You will need to create 3 tables,
the 1st to hold just customer data (cust_id, name, DoB, etc),
the 2nd to hold the account data (account_id, type & amount) and
the 3rd to cross reference the customer table with the account table by id (id, customer_id & account_id).
Good luck

Collapse -

Banking Database

by pr.garza In reply to Banking Database

Thank you for your help...being that I'm a beginner user with Access...your answer helped me quite a bit.

Collapse -

Banking Database

by john_wills In reply to Banking Database

Improving on answer 1, I suggest that the account table include the customer number, and that the account number be an extension of the customer number, e.g. 33214-01 my regular checking, 33214-03 my m/m checking, 33214-07 my long-term savings account. The extension can then indicate the kind of account, assuming that no-one has two accounts of the same kind - in fact, even if someone has, that can be handled by allowing him only 10 of a kind an having 70 thru 79 for six-month term accounts, for example. Some real-world banks do this.

Collapse -

Banking Database

by pr.garza In reply to Banking Database

Thank you for your help...being that I'm a beginner user with Access...your answer helped me quite a bit.

Collapse -

Banking Database

by Darryl Severn In reply to Banking Database

I would simply add the Customer ID as one of the fields in the Account table, and make one of the indexes based on Customer ID, Account No. as the unique identifier. You would obviously also need an index on Account No., but I would probably make ita unique index so that Account No.'s are not duplicated.

When you run your searches, you can use either index depending on requirements. The Customer ID/Account No. index needs to be built in early as so much of the coding will rely on that indexto provide the separation between accounts preventing customers from looking at or modifying accounts that aren't theirs.

Darryl

Collapse -

Banking Database

by pr.garza In reply to Banking Database

Thank you for your help...being that I'm a beginner user with Access...your answer helped me quite a bit.

Collapse -

Banking Database

by pr.garza In reply to Banking Database

This question was closed by the author

Back to Web Development Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums