 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / February 2004Access Desing tools
Can anyone sugest a good desing tool for Modeling Access database development? Microsoft, I use a big sheet of paper (A2 size), a pencil, and an eraser. - Steve Schapel, Microsoft Access MVP >Can anyone sugest a good desing tool for Modeling Access database >development? > I use a big sheet of paper (A2 size), a pencil, and an eraser. Or a big pile of Post-It notes and a blank wall. Tim F Depends on how much money you want to spend. I use: Tabloid sized sheets of paper Excel - One table per work sheet - allows entry of sample data to show client Font colors: Black for primary keys, blue for attributes, red for associations/foreign keys Visio - This can generate an access database ErWin - Try to find one of the earlier versions before they got heavy into reverse engineering. Enterprise Architect see it at http://www.netti.hu/doc/sparxsystems/ea.htm I think it is freeware. -Jim Shaw > Can anyone sugest a good desing tool for Modeling Access database > development? How do you use Visio to create a database? I can't seem to figure out how to get it to export the table definitions and relationships... - ----- Jim Shaw wrote: ---- Depends on how much money you want to spend I use Tabloid sized sheets of pape Excel - One table per work sheet - allows entry of sample data to sho clien Font colors: Black for primary keys, blue for attributes red for associations/foreign key Visio - This can generate an access databas ErWin - Try to find one of the earlier versions before they got heav into reverse engineering Enterprise Architect see it a http://www.netti.hu/doc/sparxsystems/ea.htm I think it is freeware -Jim Sha "Microsoft" <swidener@mscusa.com> wrote in messag news:O0F0ouI2DHA.1676@TK2MSFTNGP12.phx.gbl.. > Can anyone sugest a good desing tool for Modeling Access databas > development "=?Utf-8?B?TUI=?=" <mb001@wi.rr.com> wrote in news:DF95F47E-20CA-4C4F-9F1C-8E858B0CD71D@microsoft.com: > How do you use Visio to create a database? I can't seem to > figure out how to get it to export the table definitions and > relationships.... You need the Pro version -- it comes with a built in template for creating Jet and SQL Server schemas and exporting them. Tim F |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.