Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

how do i create seperate databases from a Master database?

Discussion in 'Information Technology' started by deb, Oct 28, 2005.

  1. deb

    deb
    Expand Collapse
    Guest

    I need to create seperate databases from a Master database in Access. I have
    300 investors in 9 different funds and would like to have to change thier
    info only once (rather than on 3 different excel spreadsheets). any
    suggestions?
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    deb wrote:
    >I need to create seperate databases from a Master database in Access.
    > I have 300 investors in 9 different funds and would like to have to
    > change thier info only once (rather than on 3 different excel
    > spreadsheets). any suggestions?


    A little more information please.

    300 investors
    9 funds
    3 Excel spreadsheets

    How do these numbers fit into the Master Database and why do you want
    "separate" databases?

    Generally we like to have a single database and split the information
    out of it. Having the same information in more than one database (maybe you
    mean table, but same thing there) usually leads to problems with keeping all
    of them updated properly.

    --
    Joseph Meehan

    Dia duit
     
  4. deb

    deb
    Expand Collapse
    Guest

    thanks Joseph,
    i need to seperate the databases into the different funds; however, a lot of
    investors are in more than one fund, i would like to have all thier contact
    info in one database so there is less room for error when updating contact
    info.
    If you suggest splitting please let me know how to go that route.

    i am new to Access, so any and all suggestions are appreciated.

    "Joseph Meehan" wrote:

    > deb wrote:
    > >I need to create seperate databases from a Master database in Access.
    > > I have 300 investors in 9 different funds and would like to have to
    > > change thier info only once (rather than on 3 different excel
    > > spreadsheets). any suggestions?

    >
    > A little more information please.
    >
    > 300 investors
    > 9 funds
    > 3 Excel spreadsheets
    >
    > How do these numbers fit into the Master Database and why do you want
    > "separate" databases?
    >
    > Generally we like to have a single database and split the information
    > out of it. Having the same information in more than one database (maybe you
    > mean table, but same thing there) usually leads to problems with keeping all
    > of them updated properly.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  5. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    deb wrote:
    > thanks Joseph,
    > i need to seperate the databases into the different funds;


    Do you need to separate the databases or the data? I suggest that it
    is likely that all you really need is a "Fund" filed where you identify the
    fund, You may want to create a "fund" table and link it to the main table so
    you can identify the fund that way, making it easy to add information about
    funds etc, in just one record and yet have it available for all the records
    related to that fund.

    > however, a
    > lot of investors are in more than one fund, i would like to have all
    > thier contact info in one database


    In Access that would mean a "Investor" table with all the contact
    information.

    > so there is less room for error
    > when updating contact info.
    > If you suggest splitting please let me know how to go that route.


    When first getting into Access I am I believe most people with database
    experience with other databases have a little difficulty with the lingo. A
    table is much like a database in other programs. In Access you can consider
    a database as one or more related tables all doing one job.

    Does that help?

    >
    > i am new to Access, so any and all suggestions are appreciated.
    >
    > "Joseph Meehan" wrote:
    >
    >> deb wrote:
    >> >I need to create seperate databases from a Master database in
    >> > Access. I have 300 investors in 9 different funds and would like
    >> > to have to change thier info only once (rather than on 3 different
    >> > excel spreadsheets). any suggestions?

    >>
    >> A little more information please.
    >>
    >> 300 investors
    >> 9 funds
    >> 3 Excel spreadsheets
    >>
    >> How do these numbers fit into the Master Database and why do you
    >> want "separate" databases?
    >>
    >> Generally we like to have a single database and split the
    >> information out of it. Having the same information in more than one
    >> database (maybe you mean table, but same thing there) usually leads
    >> to problems with keeping all of them updated properly.
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit


    --
    Joseph Meehan

    Dia duit
     

Share This Page