Utility for Table Schemas

Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.

A utility to develop table schemas?

If ou are looking for suggestions on how to design schemas for a variety of
needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm

In general, though, you only go go the trouble of creating a custom database
if there is no off-the-shelf solution. Therefore the bespoke Access
databases you create all have unique needs, and cannot be designed by a
utility.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Neil" wrote in message
nk.net...
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.

what do you want to do.. print schemas?
export schemas to word?

I would reccomend keeping an eye on www.gliffy.com it is a free online
visio-killer


Neil wrote:
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.

When I have seen questions concerning complex logic on newsgroups I have
wished for a sketchpad where I could draw a flowchart. Other times I have
longed to be able to share a relationship diagram. This looks like a
possible answer. I would like to hear more expert views on this.

wrote in message
ups.com...
what do you want to do.. print schemas?
export schemas to word?

I would reccomend keeping an eye on www.gliffy.com it is a free online
visio-killer


Neil wrote:
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.

I meant just a tool for playing with table designs and providing a graphical
interface/printing utility, not one that would do the designing work for me.
I want to be able to design the tables manually, set up relationships, and
print the schemas, without creating the tables, and then create the tables
once I'm done with all the design work. Seems that such a utility exists.


"Allen Browne" wrote in message
...
A utility to develop table schemas?

If ou are looking for suggestions on how to design schemas for a variety
of needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm

In general, though, you only go go the trouble of creating a custom
database if there is no off-the-shelf solution. Therefore the bespoke
Access databases you create all have unique needs, and cannot be designed
by a utility.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Neil" wrote in message
nk.net...
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.

Neil wrote:
I meant just a tool for playing with table designs and providing a graphical
interface/printing utility, not one that would do the designing work for me.
I want to be able to design the tables manually, set up relationships, and
print the schemas, without creating the tables, and then create the tables
once I'm done with all the design work. Seems that such a utility exists.

Might be, but I find small yellow stickies (post it notes) work great
when conceptualizing a design. It's certainly possible I'm in the dark
ages, though.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

I believe Microsoft's Visio might do what you want.

"Tim Marshall" wrote in message
...
Neil wrote:
I meant just a tool for playing with table designs and providing a
graphical interface/printing utility, not one that would do the designing
work for me. I want to be able to design the tables manually, set up
relationships, and print the schemas, without creating the tables, and
then create the tables once I'm done with all the design work. Seems that
such a utility exists.

Might be, but I find small yellow stickies (post it notes) work great when
conceptualizing a design. It's certainly possible I'm in the dark ages,
though.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

You can do this in Excel.

"Neil" wrote in message
nk.net...
I meant just a tool for playing with table designs and providing a
graphical interface/printing utility, not one that would do the designing
work for me. I want to be able to design the tables manually, set up
relationships, and print the schemas, without creating the tables, and then
create the tables once I'm done with all the design work. Seems that such a
utility exists.


"Allen Browne" wrote in message
...
A utility to develop table schemas?

If ou are looking for suggestions on how to design schemas for a variety
of needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm

In general, though, you only go go the trouble of creating a custom
database if there is no off-the-shelf solution. Therefore the bespoke
Access databases you create all have unique needs, and cannot be designed
by a utility.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Neil" wrote in message
nk.net...
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.

Yes, I can list tables and fields in Excel; but I'd like to visually
display table relationships and joins. Surely there must be a tool out there
that does this.

"Karl" wrote in message
t...
You can do this in Excel.

"Neil" wrote in message
nk.net...
I meant just a tool for playing with table designs and providing a
graphical interface/printing utility, not one that would do the designing
work for me. I want to be able to design the tables manually, set up
relationships, and print the schemas, without creating the tables, and
then create the tables once I'm done with all the design work. Seems that
such a utility exists.


"Allen Browne" wrote in message
...
A utility to develop table schemas?

If ou are looking for suggestions on how to design schemas for a variety
of needs, this might be useful:
http://www.databaseanswers.com/data_models/index.htm

In general, though, you only go go the trouble of creating a custom
database if there is no off-the-shelf solution. Therefore the bespoke
Access databases you create all have unique needs, and cannot be
designed by a utility.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Neil" wrote in message
nk.net...
Anyone have a recommendation for a good inexpensive or free utility for
developing table schemas.

With me, if it's not on my PC, it gets lost. The only way I find mail is by
knowing which part of the floor it was left on.... My computer files, on the
other hand, are very organized. :-)

"Tim Marshall" wrote in message
...
Neil wrote:
I meant just a tool for playing with table designs and providing a
graphical interface/printing utility, not one that would do the designing
work for me. I want to be able to design the tables manually, set up
relationships, and print the schemas, without creating the tables, and
then create the tables once I'm done with all the design work. Seems that
such a utility exists.

Might be, but I find small yellow stickies (post it notes) work great when
conceptualizing a design. It's certainly possible I'm in the dark ages,
though.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me