General discussion

  • Creator
    Topic
  • #2313167

    Banking Database

    Locked

    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?

All Comments

  • Author
    Replies
    • #3459012

      Banking Database

      by pr.garza ·

      In reply to Banking Database

      Point value changed by question poster.

    • #3460262

      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

      • #3538241

        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.

    • #3460999

      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.

      • #3538240

        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.

    • #3458461

      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

      • #3538239

        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.

    • #3538238

      Banking Database

      by pr.garza ·

      In reply to Banking Database

      This question was closed by the author

Viewing 4 reply threads