how do i create seperate databases from a Master database?

[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?

 

[Joseph Meehan]

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.

 

[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]

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?