ACC: Understanding Relational Database Design Available on MSL

 Last reviewed: January 30, 1998
Article ID: Q164172
The information in this article applies to:
  • Microsoft Access versions 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

Ureldes.doc shows you how to plan and design a database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in the Microsoft Access package. 

 ~ Reldesgn.exe (size: 126799 bytes) 

   is available for download from the Microsoft Software Library. It
   contains the following files:

   Ureldes.doc   A Microsoft Word 6.0/95 document
   Readme.txt    This Readme file
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

MORE INFORMATION

The table of contents of Ureldes.doc is as follows: 

   Overview
   The database design process
      Steps in designing a database
      Common design problems
   Determining the purpose
   Determining the tables you need
   Determining the fields you need
      Tips for determining fields
      Primary key fields
   Determining the relationships
   Refining the design
   Additional reading and practice

Keywords          : Softlib kbfile
Version           : 7.0 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 30, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.