In message <a8**************************@posting.google.com >, C. Caires
<cc*****@cosmopolita.pt> writes
I recently started working in a real estate company and I am having
serious problems on organizing their database, mostly because I had
never "put my hands" on Ms. Access. My problem is the following:
We have lots of addresses of companys and each area of activity is a
database.
Want I want to do is to gather all the databases in just one called
"Clients", which I did by importing all the tables into a single
database. But then I want to be able to search for a specific company
by filling certain fields. The fields that I have in the tables are :
company name, business, address, fax nr, e-mail, phone nr. and notes.
If I understand your situation correctly, you are trying to consolidate
a number of database that have been designed for different jobs. What
you want to do first is to move all of the client contact data into one
table.
I can come up with some suggestions for things you could do, but only
you know what the real requirements are, so you need to decide for
yourself what will work in your organisation.
You could hire someone to build a new system, and at the same time teach
you more about Access. In general I think that you will learn more about
Access by trying to build the system yourself, and by making mistakes.
You can ask questions in the newsgroup here, and all of the other people
reading the newsgroup will learn from them. I will make suggestions and
if others disagree they will make their own suggestions, and I can learn
from them.
One problem that you will need to face is that you need to continue
running the business while the new database is built. That means that
client contact details in the other databases will be changed while you
work. You need to work around this problem.
You could build a new database structure then at some time in the future
copy all of the data across and then use the new database, abandoning
the old database. Or you could build a new database and attach the data
tables from the old ones. If you do that your new database will have
current data, and your users can continue working with their old
systems. This is what I would try to do, but it may involve some complex
coding.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.