ER Diagram

[Riz]

Hi,

Ok, I have to make all the relation diagram and I dont
know how to. My freind told me that there is a way you can
import it from your Access tables????

I have visio, please let me know if there is a way to do
that..

Thanks

[Albert D. Kallal]

The ability to manage and design your tables can all be in the relationship
window.

In fact, when I want to modify a table, I use the ER or the what is called
the relationships window in ms-access.

It is real nice feature, and all you have to do is right click on any table.

In addition to being able to modify table designs, you can also set-up your
relationships between tables. So, this process should occur before you forms
and other things. I other words,you do this process as you design and
develop your application.

Simply go tools-> Relationships.

if you are using a97, then you have to download a ad-in to print the tables
and the relationships.

Of course, building your ER diagram is not somthing you do AFTER you have
created the application. It in fact is your BEST tool and BEST friend during
the development process. You can see all tables, fields and relationships. I
paste that thing on the wall in front of me. It is great.

Visio can import the tables and relation ships from ms-access, but if you
have not yet set-up your tables and relations in access yet, then Visio is
of little use. You can however create and build tables in Viso also, but I
see no need when ms-access has this ability.

Here is a screen shot of a diagram I made in visio.

[url]http://www.attcanada.net/~kallal.msn/Articles/PickSql/Appendex1.html[/url]

However, the above was just a design document. I then used the tools in
ms-access to create the tables and set-up the relationships.

The resulting ER diagram from ms-access can be seen at:
[url]http://www.attcanada.net/~kallal.msn/Articles/PickSql/Appendex2.html[/url]


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
[email]kallal@msn.com[/email]
[url]http://www.attcanada.net/~kallal.msn[/url]