Group:  Microsoft Access ยป microsoft.public.access.devtoolkits
Thread: Database Map

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Database Map
"Kan D." <nobody[ at ]nowhere.com> 22.08.2006 16:07:20
Anyone ever heard of a Database Map?

I need to create a "Database Map" for the custom database I just finished.

I don't even know where to begin! It's a little puzzling. I think the end
result should look like a flow-chart. But the map should also list all the
database objects, and how they are linked/joined with other objects (ie
queries).

Has anyone done anything like this before? Can anyone provide me a URL I
can click on to view a sample?

Thank you for your help,

Kan


Re: Database Map
"Amy Blankenship" <Amy_nospam[ at ]magnoliamultimedia.com> 22.08.2006 16:18:27
I use Word with hyperlinks. I have autotext that inserts a new preformatted
table with space for everything I document when I type "new table."

HTH;

Amy

"Kan D." <nobody[ at ]nowhere.com> wrote in message
news:OXHJNUgxGHA.4220[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text]
> Anyone ever heard of a Database Map?
>
> I need to create a "Database Map" for the custom database I just finished.
>
> I don't even know where to begin! It's a little puzzling. I think the
> end result should look like a flow-chart. But the map should also list
> all the database objects, and how they are linked/joined with other
> objects (ie queries).
>
> Has anyone done anything like this before? Can anyone provide me a URL I
> can click on to view a sample?
>
> Thank you for your help,
>
> Kan
>


RE: Database Map
MFR 22.08.2006 16:23:02
I've seen a database map that includes tables---and how they relate to one
another (one to many, etc) with all their underlying fields. I don't think it
would include queries though.

"Kan D." wrote:

[Quoted Text]
> Anyone ever heard of a Database Map?
>
> I need to create a "Database Map" for the custom database I just finished.
>
> I don't even know where to begin! It's a little puzzling. I think the end
> result should look like a flow-chart. But the map should also list all the
> database objects, and how they are linked/joined with other objects (ie
> queries).
>
> Has anyone done anything like this before? Can anyone provide me a URL I
> can click on to view a sample?
>
> Thank you for your help,
>
> Kan
>
>
>
RE: Database Map
MFR 22.08.2006 16:28:02
I should metion you can go to Access. . . .Tools. . Relationships and map it
out. I don't know all the details, but it could be a starting point.

"MFR" wrote:

[Quoted Text]
> I've seen a database map that includes tables---and how they relate to one
> another (one to many, etc) with all their underlying fields. I don't think it
> would include queries though.
>
> "Kan D." wrote:
>
> > Anyone ever heard of a Database Map?
> >
> > I need to create a "Database Map" for the custom database I just finished.
> >
> > I don't even know where to begin! It's a little puzzling. I think the end
> > result should look like a flow-chart. But the map should also list all the
> > database objects, and how they are linked/joined with other objects (ie
> > queries).
> >
> > Has anyone done anything like this before? Can anyone provide me a URL I
> > can click on to view a sample?
> >
> > Thank you for your help,
> >
> > Kan
> >
> >
> >
Re: Database Map
"Kan D." <nobody[ at ]nowhere.com> 22.08.2006 16:39:20
Thank you, Amy...

Could you provide me with an example of what this looks like? I'm a little
confused.

Thanks,
Kan
"Amy Blankenship" <Amy_nospam[ at ]magnoliamultimedia.com> wrote in message
news:umezaagxGHA.2304[ at ]TK2MSFTNGP02.phx.gbl...
[Quoted Text]
>I use Word with hyperlinks. I have autotext that inserts a new
>preformatted table with space for everything I document when I type "new
>table."
>
> HTH;
>
> Amy
>
> "Kan D." <nobody[ at ]nowhere.com> wrote in message
> news:OXHJNUgxGHA.4220[ at ]TK2MSFTNGP06.phx.gbl...
>> Anyone ever heard of a Database Map?
>>
>> I need to create a "Database Map" for the custom database I just
>> finished.
>>
>> I don't even know where to begin! It's a little puzzling. I think the
>> end result should look like a flow-chart. But the map should also list
>> all the database objects, and how they are linked/joined with other
>> objects (ie queries).
>>
>> Has anyone done anything like this before? Can anyone provide me a URL I
>> can click on to view a sample?
>>
>> Thank you for your help,
>>
>> Kan
>>
>
>


Re: Database Map
"Pat Hartman\(MVP\)" <patsky[ at ]NoSpam.optonline.net> 22.08.2006 18:23:08
I have a tool called Total Access Analyzer. It is sold by www.FMSInc.com.
I have been using it for years and it has been very helpful in documenting
databases built by other people. It produces hundreds of reports including
the type of cross reference you are looking for. It also points out errors
and inconsistencies.

"Kan D." <nobody[ at ]nowhere.com> wrote in message
news:OXHJNUgxGHA.4220[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text]
> Anyone ever heard of a Database Map?
>
> I need to create a "Database Map" for the custom database I just finished.
>
> I don't even know where to begin! It's a little puzzling. I think the
> end result should look like a flow-chart. But the map should also list
> all the database objects, and how they are linked/joined with other
> objects (ie queries).
>
> Has anyone done anything like this before? Can anyone provide me a URL I
> can click on to view a sample?
>
> Thank you for your help,
>
> Kan
>


Re: Database Map
"John Goodfellow" <nospam[ at ]bitbucket.net> 23.08.2006 12:52:12
You might also look at MS Visio. Pretty easy to do basic flow charts. Also
has the ability to connect to a live database. A free trial (90 days?) is
available for download.
--
John G.

"Kan D." <nobody[ at ]nowhere.com> wrote in message
news:OXHJNUgxGHA.4220[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text]
> Anyone ever heard of a Database Map?
>
> I need to create a "Database Map" for the custom database I just finished.
>
> I don't even know where to begin! It's a little puzzling. I think the
> end result should look like a flow-chart. But the map should also list
> all the database objects, and how they are linked/joined with other
> objects (ie queries).
>
> Has anyone done anything like this before? Can anyone provide me a URL I
> can click on to view a sample?
>
> Thank you for your help,
>
> Kan
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net