AnsweredAssumed Answered

How to best document a database?

Question asked by LeoB on Jan 16, 2010
Latest reply on Jan 16, 2010 by davidanders

Title

How to best document a database?

Post

First -- I'm NOT a database professional.  I've got a death grip on reckless amateur status.

 

I've created a database to use in my work in FP10 with three tables, one very large table and two smaller supporting tables.  My design document was substantially changed as I learned things (mostly from this forum) and reduced the database from nine tables to three.

 

I've been trying to do documentation as I go along using paper, pencil, and a BIG eraser.  But, I'm not sure I'm capturing everything I should.  I'm not using anything fancy (yet) like script triggers, global fields, etc. 

 

I've searched this forum and other places for a good example of database documentation for FP10 or Access and found one or two, but those were for SQL databases.  I want to start converting the documentation into Word or Excel (any preference?), but it would make it easier if I formatted it halfway right from the beginning.

 

Any recommendations?

 

 

Outcomes