Results 1 to 4 of 4
  1. #1
    r_pathiyil is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    2

    Table Design


    I have different types of investments (eg: gold, land, fix deposit, savings bank, mutual fund etc...) all having different information, how to make tables and relate each other so that I could get one brief report as well as breakup reports.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You don't need separate tAbles for gold, land,etc.
    it should be 1 table , tProperty.
    the records would be,
    gold
    land
    diamonds

    a table for tBanks
    a table for items in the bank, tBankAccts
    The acct records,
    checking
    mutual fund
    etc

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I would suggest you do some reading about database design and normalization.

    "Old Programmer's Rule" is this: If you can't do it on paper then you can't do it in Access. Until you can draw out your tables AND rules for how they change for each function you want to perform, you are going nowhere fast.



    Fundamentals of Relational Database Design
    http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf



    Database Design Basics

    Entity-Relationship Diagramming: Part I,
    http://rogersaccessblog.blogspot.com...ng-part-i.html

    Normalization Parts I, II, III, IV, and V,
    http://rogersaccessblog.blogspot.ca/...on-part-i.html


    How do I Create an Application in Microsoft Access?
    http://rogersaccessblog.blogspot.com...cation-in.html




    Here is a link to some youtube videos you should watch:
    https://www.accessforums.net/showthread.php?t=62566
    See Post #3

  4. #4
    r_pathiyil is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2016
    Posts
    2
    Click image for larger version. 

Name:	relationship.png 
Views:	10 
Size:	186.0 KB 
ID:	26208
    this is my current database relation how to normalize this

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

Similar Threads

  1. Replies: 1
    Last Post: 09-19-2016, 12:03 PM
  2. Replies: 3
    Last Post: 04-27-2014, 08:08 PM
  3. Table Design -- want to avoid a design that creates blank fields
    By snowboarder234 in forum Database Design
    Replies: 4
    Last Post: 10-08-2012, 10:13 AM
  4. Replies: 8
    Last Post: 03-24-2012, 11:03 AM
  5. table design: one big table vs. multiple small tables
    By lstairs in forum Database Design
    Replies: 3
    Last Post: 12-31-2009, 08:46 AM

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