By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,935 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Database Design Software

P: n/a
Hello all,

I would like to find a piece of software which would allow me to draw
out the design of a database, rather than trying to keep it in my head
and bits of paper. There are lots of options for open source
databases, e.g. MySQL Workbench. Are there any which are appropriate
for Access database designing? I use Access 2003.

Thanks,

Franc.
Sep 10 '08 #1
Share this Question
Share on Google+
7 Replies


P: n/a
franc sutherland <fr**************@googlemail.comwrote:
>I would like to find a piece of software which would allow me to draw
out the design of a database, rather than trying to keep it in my head
and bits of paper. There are lots of options for open source
databases, e.g. MySQL Workbench. Are there any which are appropriate
for Access database designing? I use Access 2003.
If you are just concerned about tables use the relationships window in Access. Once
you've created a few fields in a table and added it to the relationships you can then
right click on it and update it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Sep 11 '08 #2

P: n/a
The site below lists some of the various kinds of data modeling tools
that are available. Some of these will allow you to draw a design and
then automatically generate a database from that, among other features.

I think most of them support Access, but I'm not 100% on that.

http://www.databaseanswers.com/modelling_tools.htm

-Carlos

"Tony Toews [MVP]" <tt****@telusplanet.netwrote in
news:en********************************@4ax.com:
franc sutherland <fr**************@googlemail.comwrote:
>>I would like to find a piece of software which would allow me to draw
out the design of a database, rather than trying to keep it in my head
and bits of paper. There are lots of options for open source
databases, e.g. MySQL Workbench. Are there any which are appropriate
for Access database designing? I use Access 2003.

If you are just concerned about tables use the relationships window in
Access. Once you've created a few fields in a table and added it to
the relationships you can then right click on it and update it.

Tony
Sep 11 '08 #3

P: n/a
On Sep 11, 2:19*am, "Carlos Nunes-Ueno" <sulla...@athotmaildot.com>
wrote:
The site below lists some of the various kinds of data modeling tools
that are available. *Some of these will allow you to draw a design and
then automatically generate a database from that, among other features.

I think most of them support Access, but I'm not 100% on that.

http://www.databaseanswers.com/modelling_tools.htm

-Carlos

"Tony Toews [MVP]" <tto...@telusplanet.netwrote innews:en********************************@4ax.com:
franc sutherland <franc.sutherl...@googlemail.comwrote:
>I would like to find a piece of software which would allow me to draw
out the design of a database, rather than trying to keep it in my head
and bits of paper. *There are lots of options for open source
databases, e.g. MySQL Workbench. *Are there any which are appropriate
for Access database designing? *I use Access 2003.
If you are just concerned about tables use the relationships window in
Access. *Once you've created a few fields in a table and added it to
the relationships you can then right click on it and update it.
Tony
Thanks Tony, Thanks Carlos.
Both good suggestions.
There was a useful add-on for Eclipse at the modelling tools site
which I've downloaded.
All the best,
Franc.
Sep 12 '08 #4

P: n/a
franc sutherland <fr**************@googlemail.comwrote in news:1a5aabc6-
5f*************************@x41g2000...legrou ps.com:
Hello all,

I would like to find a piece of software which would allow me to draw
out the design of a database, rather than trying to keep it in my head
and bits of paper. There are lots of options for open source
databases, e.g. MySQL Workbench. Are there any which are appropriate
for Access database designing? I use Access 2003.
If you were to move to SQLExpress (free) you could use the SQL Server
Management Studio (free) which provides a powerful Diagram Dialog/Utility.
I create tables, relationships, and indexes there.

Of course, there are 7968345 other benfits to moving to SQLExpress; it's
not just another pretty face.

--
-
lyle fairfield
Sep 12 '08 #5

P: n/a
"lyle fairfield" <ly******@yah00.cawrote
Of course, there are 7968345 other benfits to
moving to SQLExpress; it's not just another pretty face.
Just as a matter of personal interest, what is benefit number 6498743? :-)

You been lurking in microsoft.public.access again and reading the responses
of Mr. Aaron Kempf, again, Lyle?

Larry
Sep 14 '08 #6

P: n/a
"Larry Linson" <bo*****@localhost.notwrote in
news:q2%yk.119$8v5.27@trnddc01:

Just as a matter of personal interest, what is benefit number 6498743?
That a linked server can be created with a procedure.

CREATE Procedure [dbo].[LinkToOPEExcelFile]
@FileLocation nvarchar(255)
AS
IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0
AND srv.name = N'OPE_XLS')
EXEC master.dbo.sp_dropserver @server=N'OPE_XLS',
@droplogins='droplogins'

EXEC master.dbo.sp_addlinkedserver
@server = N'OPE_XLS',
@srvproduct=N'Excel',
@provider=N'Microsoft.Jet.OLEDB.4.0',
@datasrc=@FileLocation,
@provstr=N'Excel 8.0'

This can be useful when modifying a client db; it does not require the
laying on of hands.
You been lurking in microsoft.public.access again
I haven't been in a Microsoft group since I was banished several years
ago (after all my knitted polyester suits wore out) for not dressing
appropriately. Apparently attire must match the ideas tossed about in MS
groups.
and reading the
responses of Mr. Aaron Kempf, again, Lyle?
Aaron sometimes (often?) has useful knowledge and experience. Delivery in
his M1 Abrams tank may not be so effective.

--
-
lyle fairfield
Sep 16 '08 #7

P: n/a
"lyle fairfield" <ly******@yah00.cawrote
I haven't been in a Microsoft group since I was
banished several years ago (after all my knitted
polyester suits wore out) for not dressing
appropriately. Apparently attire must match the
ideas tossed about in MS groups.
If only you hadn't "fessed up" that you were "sittin' here at th' keyboard,
nekkid as th' day I'z born". <SIGH>

Sep 16 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.