Re: Database Design Software

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]" <ttoews@xxxxxxxxxxxxxxx> wrote in
news:enrgc4l9eu0ooo6bqenjggqeidvrgrn22n@xxxxxxx:

franc sutherland <franc.sutherland@xxxxxxxxxxxxxx> wrote:

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

.

Relevant Pages

  • C# programmer looking for a job
    ... Software Development including Desktop, Client/Server and Database ... Practical skills in object oriented design and design patterns ... XML, Oracle, CVS, VSS, Delphi, bug tracking. ... Developed in Delphi5; ...
    (misc.immigration.usa)
  • Re: O/R Mapper
    ... | - create E/R model from niam model ... classes that contain, not only data, but also functionality as OO design is ... a database where they do not exist in the object model is corrupting the ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Date range on reports
    ... > box to your report with a control source like: ... >> In the Database window (Database window: The window that appears when you ... >> In the New Form dialog box, click Design View, and click OK. ... >> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: teaching relational basics to people, questions
    ... the number of tables in the design, and think that conflating multiple fact ... metadata heaven where we have all of the formal semantics of our data ... model neatly encoded within the database catalog, and further, we have ... So I think this thing is mostly about UI design and formal conceptual ...
    (comp.databases.theory)
  • Re: O/R Mapper
    ... > as OO design is not just about data in isolation. ... the proper tooling/methods are used which fit with the approach chosen. ... >> of the reality to come to the proper result. ... > constraints into a database where they do not exist in the object ...
    (microsoft.public.dotnet.languages.csharp)