Results 1 to 5 of 5
  1. #1
    CLFz is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2016
    Posts
    3

    Help needed in table creation and their relationships (for use in cash account record)

    Dear users,

    I am learning MS Access and can create a simple table, query, forms etc but I'm not an advanced user.
    Now I want to make access database for my organization. We have four bank accounts in four (4) different banks, say Bank A, Bank B, Bank C and Bank D. We deposit and withdrawn very often from these 4 banks. Now I want to create database which will record all the banks transactions, suppose if we deposit in Bank A, the amount will be increased, and if we make withdrawal from Bank A, the balance amount will be decreased. And also any transactions date will be recorded. And when we make withdrawal there should be a 'note field' or something like that in which we enter like 'Reason for Withdrawal'.

    I will be very grateful if you help me out in this problem.
    I'm sorry for my bad english.
    Thaks in advance.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Sounds do-able. Youd have a tBank table
    A
    B
    C

    then a tTransaction table, which could hold all transactions from all banks
    [bank],[acct#],[TransType], [Amt]
    A, 20124,Deposit,$23.00
    B,99483,Withdrawal,$234.32

    tAccts
    [bank],[acct#],[name],[balance]
    A, 20124, john smith, $4,500.00

    all transactions record to the tTrans table while adding/subtracting the tAcct table.

  3. #3
    CLFz is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2016
    Posts
    3
    Thanks very much.
    To calculate the balance in the tAccts table, using a query or calculated field. Im using Access 2007.

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the balance is a field. youd add/subtract.
    if you want balance in ALL that persons accts, then youd use a query.

  5. #5
    CLFz is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2016
    Posts
    3
    Thank you i got it. But if i use a form to make an entry (deposit/withdraw) so that amount will be automatic addition/subtraction with balance amount?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 11-12-2015, 05:25 AM
  2. Replies: 6
    Last Post: 02-02-2015, 08:22 PM
  3. Replies: 8
    Last Post: 07-18-2013, 01:52 PM
  4. Replies: 1
    Last Post: 12-31-2012, 12:48 PM
  5. Replies: 12
    Last Post: 06-09-2011, 09:15 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums